<!DOCTYPE html>
<html lang="en" class="svg no-js">
<head>
    <meta charset="utf-8" />
    <!--[if IE ]>
    <meta http-equiv="X-UA-Compatible" content="IE=Edge,chrome=1" />
    <![endif]-->
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
        <meta name="Language" content="en">

    <title>MySQL :: MySQL 8.0 Reference Manual :: INFORMATION_SCHEMA Index</title>
    <link rel="stylesheet" media="all" href="css/main-20190125.min.css" />
            <link rel="stylesheet" media="all" href="css/docs-20190125.min.css" />
    
    
    <link rel="stylesheet" media="print" href="css/print-20190125.min.css" />

    
    
    
    
            <link rel="contents" href="index.html" title="MySQL 8.0 Reference Manual" />
<link rel="start" href="index.html" title="MySQL 8.0 Reference Manual" />
<link rel="prev" href="dynindex-function.html" title=" Function Index" />
<link rel="next" href="dynindex-jointype.html?ff=nopfpls" title=" Join Types Index" />
<link rel="up" href="indexes.html" title="D Indexes" />

    
    <link rel="shortcut icon" href="favicon.ico" />
    <script>(function(H){ H.className=H.className.replace(/\bno-js\b/,'js') })(document.documentElement)</script>
    <script src="js/site-20181120.min.js"></script>

    
    
    
    <!--[if lt IE 9]>
        <script src="https://labs.mysql.com/common/js/polyfills/html5shiv-printshiv-3.7.2.min.js"></script>
        <script src="https://labs.mysql.com/common/js/polyfills/respond-1.4.2.min.js"></script>
    <![endif]-->
        <!--[if IE 9]>
        <style>#docs-sidebar-toc { box-sizing: content-box; }</style>
    <![endif]-->
    </head>

<body class="no-sidebar full-page dev">
<div class="page-wrapper">
    <header>

                        <a href="https://dev.mysql.com/" aria-label="Home" title="MySQL" id="l1-home-link"></a>
        
        <div id="l1-nav-container">
            <div id="l1-line1">
                <div id="l1-auth-links">
                    <a href="https://www.mysql.com/about/contact/"><b>Contact MySQL</b></a>
                    <span id="l1-contact-separator">&nbsp;|&nbsp;</span>
                    <span id="l1-contact-separator-br"><br /></span>
                                             <a href="https://dev.mysql.com/auth/login/?dest=https%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F8.0%2Fen%2Fdynindex-is.html">Login</a> &nbsp;|&nbsp;
                         <a href="https://dev.mysql.com/auth/register/">Register</a>
                                    </div>
                <div id="l1-lhs">
                    <div id="l1-slogan">
                        The world's most popular open source database
                    </div>
                    <div id="l1-search-box">
                        <form id="l1-search-form" method="get" action="https://www.oracle.com/search/results">
                        <input type="hidden" name="cat" value="mysql" />
                        <input type="hidden" name="Ntk" value="SI-ALL5" />
                        <input id="l1-search-input" type="search" class="icon-search" placeholder="Search" aria-label="Search" name="Ntt" />
                        </form>
                    </div>
                </div>
            </div>
            <div id="l1-line2">
                <div class="social-icons">
                    <a aria-label="Join us on Facebook" title="Join us on Facebook" href="http://www.facebook.com/mysql"><span class="icon-facebook"></span></a>
                    <a aria-label="Follow us on Twitter" title="Follow us on Twitter" href="https://twitter.com/mysql"><span class="icon-twitter"></span></a>
                    <a aria-label="Follow us on LinkedIn" title="Follow us on LinkedIn" href="https://www.linkedin.com/company/mysql"><span class="icon-linkedin"></span></a>
                    <a aria-label="Visit our YouTube channel" title="Visit our YouTube channel" href="http://www.youtube.com/mysqlchannel"><span class="icon-youtube"></span></a>
                </div>
                <ul id="l1-nav">
                    <li>
                        <a href="https://www.mysql.com/"><!-- <span class="icon-sakila"></span>  -->MySQL.com</a>
                    </li><li>
                        <a href="https://www.mysql.com/downloads/"><!-- <span class="icon-download-thin"></span>  -->Downloads</a>
                    </li><li class="active">
                        <a href="/doc/"><!-- <span class="icon-books"></span>  -->Documentation</a>
                    </li><li>
                        <a href="/"><!-- <span class="icon-code"></span>  -->Developer Zone</a>
                    </li>                </ul>
            </div>
        </div>
        <div id="sub-header">
            <div id="l2-nav-container">
                <div id="l2-nav-toggle">
                    <span class="icon-three-bars"></span>
                </div>
                                                                                        <a class="button nav-button-3" href="/"><span class="icon-code"></span> Developer Zone</a>
                                                                                                                                    <a class="button nav-button-2" href="https://www.mysql.com/downloads/"><span class="icon-download-thin"></span> Downloads</a>
                                                                                                <a class="button nav-button-1" href="https://www.mysql.com/"><span class="icon-sakila"></span> MySQL.com</a>
                                                                        <div id="l2-search-toggle">
                    <span class="icon-search"></span>
                </div>
                <div id="l2-site-icon">
                                                                                                                                                                                                    <span class="icon-books"></span>
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        </div>
                <div id="l1-section-title">
                    <span id="l1-section-label">
                        <a href="/doc/">Documentation</a>
                    </span>
                </div>
                <nav>
                    

<ul id="l2-nav">
            	<li class="active"><a class="active " href="/doc/refman/en/">MySQL Server</a>
    			</li>
	        	<li class=""><a  href="/doc/index-enterprise.html">MySQL Enterprise</a>
    			</li>
	        	<li class=""><a  href="/doc/workbench/en/">Workbench</a>
    			</li>
	        	<li class=""><a  href="/doc/en/mysql-innodb-cluster-userguide.html">InnoDB Cluster</a>
    			</li>
	        	<li class=""><a  href="/doc/index-cluster.html">MySQL NDB Cluster</a>
    			</li>
	        	<li class=""><a  href="/doc/index-connectors.html">Connectors</a>
    			</li>
	        	<li class=" last"><a  href="/doc/index-other.html">More</a>
    			</li>
	                        <li class="other-section"><a href="https://www.mysql.com/">MySQL.com</a></li>
                            <li class="other-section"><a href="https://www.mysql.com/downloads/">Downloads</a></li>
                                        <li class="other-section"><a href="/">Developer Zone</a></li>
            </ul>
                </nav>
            </div>
            <div id="l3-search-container"></div>
            <div id="top-orange"><span id="section-nav">Section Menu: &nbsp; </span></div>
        </div>
    </header>
        <div id="page">
                        <div role="main" id="main">

            
                
            
<div>
    <div id="docs-sidebar-toc" class="">
    <div id="docs-toc-inner">
        <div class="docs-sidebar-header" id="docs-nav-header">
            <a class="docs-show-hide-nav" id="docs-hide-nav" href="" title="Hide Sidebar" aria-label="Hide Sidebar"><span class="icon-arrow-small-left"></span></a>
            <div class="docs-nav-links">
                                    
    <a href="dynindex-function.html"
        aria-label="Previous" title="Previous: Function Index"><span
        class="icon-chevron-left"></span></a>
<a href="index.html" aria-label="Start" title="Start"><span class="icon-book-open"></span></a>
        <a aria-label="Up" href="indexes.html" title="Up: Indexes"><span class="icon-chevron-up"></span></a>
    <a href="dynindex-jointype.html" aria-label="Next"
        title="Next: Join Types Index"><span
        class="icon-chevron-right"></span></a>
                            </div>
        </div>
                    
<div id="docs-sidebar-search-container">
    <div id="docs-sidebar-search-box">
        <form method="get" action="/mysql-manual/search-page">
            <input type="hidden" name="d" id="d" value="201" />
            <input type="hidden" name="p" id="p" value="1" />
            <input type="text" name="keyword" id="q" title="Search this Manual"
                value=""
                style="color: #bbb;"
                onfocus=""
                onblur="" />

            <button class="docs-sidebar-search-btn" aria-label="Search" title="Search" type="submit">
                <span class="icon-search"></span>
            </button>
        </form>
    </div>
</div>
                <div class="docs-sidebar-nav">
            <a class="docs-icon-home" href="/doc/"><span class="icon-home"></span>Documentation Home</a><hr />
            <div class="docs-sidebar-mtitle">MySQL 8.0 Reference Manual</div>
            <nav class="doctoc" id="doc-201">
                                    
    <ul>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="preface.html">Preface and Legal Notices</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="introduction.html">General Information</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="installing.html">Installing and Upgrading MySQL</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="tutorial.html">Tutorial</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="programs.html">MySQL Programs</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="server-administration.html">MySQL Server Administration</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="security.html">Security</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="backup-and-recovery.html">Backup and Recovery</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="optimization.html">Optimization</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="language-structure.html">Language Structure</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="charset.html">Character Sets, Collations, Unicode</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="data-types.html">Data Types</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="functions.html">Functions and Operators</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="sql-syntax.html">SQL Statement Syntax</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="data-dictionary.html">MySQL Data Dictionary</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="innodb-storage-engine.html">The InnoDB Storage Engine</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="storage-engines.html">Alternative Storage Engines</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="replication.html">Replication</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="group-replication.html">Group Replication</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="mysql-shell-userguide.html">MySQL Shell</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="document-store.html">Using MySQL as a Document Store</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="mysql-innodb-cluster-userguide.html">InnoDB Cluster</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="mysql-cluster.html">MySQL NDB Cluster 8.0</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="partitioning.html">Partitioning</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="stored-objects.html">Stored Objects</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="information-schema.html">INFORMATION_SCHEMA Tables</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="performance-schema.html">MySQL Performance Schema</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="sys-schema.html">MySQL sys Schema</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="connectors-apis.html">Connectors and APIs</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="extending-mysql.html">Extending MySQL</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="mysql-enterprise.html">MySQL Enterprise Edition</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="workbench.html">MySQL Workbench</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="faqs.html">MySQL 8.0 Frequently Asked Questions</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="error-handling.html">Errors, Error Codes, and Common Problems</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="restrictions.html">Restrictions and Limits</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable  loaded" aria-label="Subnav" href=""><span class="icon-chevron-down"></span></a></div><div class="docs-sidebar-nav-link"><a href="indexes.html">Indexes</a></div></div>                        <div class="docs-submenu">
                                    
    <ul>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="ix01.html">General Index</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="dynindex-cfunc.html">Function Index</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="dynindex-command.html">Command Index</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="dynindex-function.html">Function Index</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link current"><a href="dynindex-is.html">INFORMATION_SCHEMA Index</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="dynindex-jointype.html">Join Types Index</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="dynindex-operator.html">Operator Index</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="dynindex-option.html">Option Index</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="dynindex-priv.html">Privileges Index</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="dynindex-sqlmode.html">Modes Index</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="dynindex-statement.html">Statement/Syntax Index</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="dynindex-statvar.html">Status Variable Index</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="dynindex-sysvar.html">System Variable Index</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="dynindex-isolevel.html">Transaction Isolation Level Index</a></div></div>                    </li>
        </ul>
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="glossary.html">MySQL Glossary</a></div></div>                    </li>
        </ul>
                            </nav>
        </div>

        
<a class="docs-sidebar-section" href=""><span class="icon-related"></span>
    <span class="text">Related Documentation</span></a>
<div class="docs-sidebar-accordian open">
    <div class="text">
        <a href="/doc/relnotes/mysql/8.0/en/">MySQL 8.0 Release Notes</a><br />
        <a href="/doc/dev/mysql-server/latest/">MySQL 8.0 Source Code Documentation</a><br />
        </div>
</div>

    <a class="docs-sidebar-section" href=""><span class="icon-download-thin"></span>
        <span class="text">
            Download
                            this Manual
                    </span>
    </a>
    <div class="docs-sidebar-accordian open">
        <div class="text">
                        <a href="https://downloads.mysql.com/docs/refman-8.0-en.pdf">PDF (US Ltr)</a>
            - 46.1Mb<br />
                        <a href="https://downloads.mysql.com/docs/refman-8.0-en.a4.pdf">PDF (A4)</a>
            - 46.1Mb<br />
                        <a href="https://downloads.mysql.com/docs/mysql-ref-manual-8.0-en-pdf-1-20190611.noarch.rpm">PDF (RPM)</a>
            - 41.5Mb<br />
                        <a href="https://downloads.mysql.com/docs/refman-8.0-en.html-chapter.tar.gz">HTML Download (TGZ)</a>
            - 10.6Mb<br />
                        <a href="https://downloads.mysql.com/docs/refman-8.0-en.html-chapter.zip">HTML Download (Zip)</a>
            - 10.6Mb<br />
                        <a href="https://downloads.mysql.com/docs/mysql-ref-manual-8.0-en-html-chapter-1-20190611.noarch.rpm">HTML Download (RPM)</a>
            - 9.1Mb<br />
                        <a href="https://downloads.mysql.com/docs/refman-8.0-en.man-gpl.tar.gz">Man Pages (TGZ)</a>
            - 220.4Kb<br />
                        <a href="https://downloads.mysql.com/docs/refman-8.0-en.man-gpl.zip">Man Pages (Zip)</a>
            - 325.8Kb<br />
                        <a href="https://downloads.mysql.com/docs/mysql-8.0.info.gz">Info (Gzip)</a>
            - 4.1Mb<br />
                        <a href="https://downloads.mysql.com/docs/mysql-8.0.info.zip">Info (Zip)</a>
            - 4.1Mb<br />
                    </div>
    </div>

<a class="docs-sidebar-section" href=""><span class="icon-book"></span>
    <span class="text">Excerpts from this Manual</span></a>
<div class="docs-sidebar-accordian">
    <div class="text">
                <a href="/doc/mysql-backup-excerpt/8.0/en/">MySQL Backup and Recovery</a><br />
                <a href="/doc/mysql-g11n-excerpt/8.0/en/">MySQL Globalization</a><br />
                <a href="/doc/mysql-infoschema-excerpt/8.0/en/">MySQL Information Schema</a><br />
                <a href="/doc/mysql-installation-excerpt/8.0/en/">MySQL Installation Guide</a><br />
                <a href="/doc/mysql-security-excerpt/8.0/en/">Security in MySQL</a><br />
                <a href="/doc/mysql-startstop-excerpt/8.0/en/">Starting and Stopping MySQL</a><br />
                <a href="/doc/mysql-linuxunix-excerpt/8.0/en/">MySQL and Linux/Unix</a><br />
                <a href="/doc/mysql-windows-excerpt/8.0/en/">MySQL and Windows</a><br />
                <a href="/doc/mysql-osx-excerpt/8.0/en/">MySQL and OS X</a><br />
                <a href="/doc/mysql-solaris-excerpt/8.0/en/">MySQL and Solaris</a><br />
                <a href="/doc/mysql-sourcebuild-excerpt/8.0/en/">Building MySQL from Source</a><br />
                <a href="/doc/mysql-reslimits-excerpt/8.0/en/">MySQL Restrictions and Limitations</a><br />
                <a href="/doc/mysql-partitioning-excerpt/8.0/en/">MySQL Partitioning</a><br />
                <a href="/doc/mysql-secure-deployment-guide/8.0/en/">MySQL Secure Deployment Guide</a><br />
                <a href="/doc/mysql-tutorial-excerpt/8.0/en/">MySQL Tutorial</a><br />
                <a href="/doc/mysql-perfschema-excerpt/8.0/en/">MySQL Performance Schema</a><br />
                <a href="/doc/mysql-replication-excerpt/8.0/en/">MySQL Replication</a><br />
                <a href="/doc/mysql-repo-excerpt/8.0/en/">Using the MySQL Yum Repository</a><br />
            </div>
</div>

        <br /><span id="wkr"><br /></span>
    </div>
    </div>

    <div id="docs-main" class="has-toc">
    <div id="docs-main-inner">

                <div class="right" id="docs-version-nav">
            <a href="" id="docs-version-nav-toggle">version 8.0
            <span class="icon-chevron-down"></span></a>
            <div id="docs-version-list">
                                                                                            <a                         href="/doc/refman/5.7/en/dynindex-is.html">
                        5.7
                                            </a><br />
                                                                            <a                         href="/doc/refman/5.6/en/dynindex-is.html">
                        5.6
                                            </a><br />
                                                                            <a                         href="/doc/refman/5.5/en/dynindex-is.html">
                        5.5
                                            </a><br />
                                                                        <div id="docs-version-nav-lang">
                                                                                                                                                    <a                                     href="/doc/refman/5.6/ja/dynindex-is.html">
                                    5.6&nbsp;
                                                                            Japanese
                                                                    </a><br />
                                                                                            </div>
                            </div>
        </div>
        
        <div id="docs-show-nav" class="left hidden" style="margin-right: 15px;">
            <a class="docs-show-hide-nav" href="" aria-label="Show Sidebar"
                title="Show Sidebar"><span class="icon-arrow-small-right"></span></a>
        </div>

                        <div id="docs-breadcrumbs">
            <a href="/doc/refman/8.0/en/">MySQL 8.0 Reference Manual</a> &nbsp;/&nbsp;
                                                        <a href="indexes.html">Indexes</a> &nbsp;/&nbsp;
                                                                                    INFORMATION_SCHEMA Index
                                    </div>
        
        <div id="docs-body">
        
<div class="index">

<div class="titlepage">
<div>
<div>
<h2 class="title"><a name="dynindex-is"></a>INFORMATION_SCHEMA Index</h2>

</div>

</div>

</div>
<p><a name="is-index-top"></a><a class="link" href="dynindex-is.html#is-index-C" title="C">C</a> | <a class="link" href="dynindex-is.html#is-index-E" title="E">E</a> | <a class="link" href="dynindex-is.html#is-index-F" title="F">F</a> | <a class="link" href="dynindex-is.html#is-index-G" title="G">G</a> | <a class="link" href="dynindex-is.html#is-index-I" title="I">I</a> | <a class="link" href="dynindex-is.html#is-index-K" title="K">K</a> | <a class="link" href="dynindex-is.html#is-index-N" title="N">N</a> | <a class="link" href="dynindex-is.html#is-index-O" title="O">O</a> | <a class="link" href="dynindex-is.html#is-index-P" title="P">P</a> | <a class="link" href="dynindex-is.html#is-index-R" title="R">R</a> | <a class="link" href="dynindex-is.html#is-index-S" title="S">S</a> | <a class="link" href="dynindex-is.html#is-index-T" title="T">T</a> | <a class="link" href="dynindex-is.html#is-index-U" title="U">U</a> | <a class="link" href="dynindex-is.html#is-index-V" title="V">V</a></p>
<div class="indexdiv">
<a name="is-index-C"></a><h3 class="title">C</h3>
<p>[<a class="link" href="dynindex-is.html#is-index-top">index top</a>]</p><dl><dt></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">CHARACTER_SETS</h3>
<dl><dt><a class="xref" href="charset-introducer.html" title="10.3.8 Character Set Introducers">Section 10.3.8, “Character Set Introducers”</a></dt><dd></dd><dt><a class="xref" href="charset-mysql.html" title="10.2 Character Sets and Collations in MySQL">Section 10.2, “Character Sets and Collations in MySQL”</a></dt><dd></dd><dt><a class="xref" href="charset-literal.html" title="10.3.6 Character String Literal Character Set and Collation">Section 10.3.6, “Character String Literal Character Set and Collation”</a></dt><dd></dd><dt><a class="xref" href="charset-column.html" title="10.3.5 Column Character Set and Collation">Section 10.3.5, “Column Character Set and Collation”</a></dt><dd></dd><dt><a class="xref" href="charset-database.html" title="10.3.3 Database Character Set and Collation">Section 10.3.3, “Database Character Set and Collation”</a></dt><dd></dd><dt><a class="xref" href="data-dictionary-information-schema.html" title="14.5 INFORMATION_SCHEMA and Data Dictionary Integration">Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”</a></dt><dd></dd><dt><a class="xref" href="show-character-set.html" title="13.7.6.3 SHOW CHARACTER SET Syntax">Section 13.7.6.3, “SHOW CHARACTER SET Syntax”</a></dt><dd></dd><dt><a class="xref" href="charset-charsets.html" title="10.10 Supported Character Sets and Collations">Section 10.10, “Supported Character Sets and Collations”</a></dt><dd></dd><dt><a class="xref" href="charset-table.html" title="10.3.4 Table Character Set and Collation">Section 10.3.4, “Table Character Set and Collation”</a></dt><dd></dd><dt><a class="xref" href="character-sets-table.html" title="25.2 The INFORMATION_SCHEMA CHARACTER_SETS Table">Section 25.2, “The INFORMATION_SCHEMA CHARACTER_SETS Table”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">CHECK_CONSTRAINTS</h3>
<dl><dt><a class="xref" href="data-dictionary-information-schema.html" title="14.5 INFORMATION_SCHEMA and Data Dictionary Integration">Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”</a></dt><dd></dd><dt><a class="xref" href="check-constraints-table.html" title="25.3 The INFORMATION_SCHEMA CHECK_CONSTRAINTS Table">Section 25.3, “The INFORMATION_SCHEMA CHECK_CONSTRAINTS Table”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">COLLATION_CHARACTER_SET_APPLICABILITY</h3>
<dl><dt><a class="xref" href="data-dictionary-information-schema.html" title="14.5 INFORMATION_SCHEMA and Data Dictionary Integration">Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”</a></dt><dd></dd><dt><a class="xref" href="information-schema-optimization.html" title="8.2.3 Optimizing INFORMATION_SCHEMA Queries">Section 8.2.3, “Optimizing INFORMATION_SCHEMA Queries”</a></dt><dd></dd><dt><a class="xref" href="collation-character-set-applicability-table.html" title="25.5 The INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY Table">Section 25.5, “The INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY Table”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">COLLATIONS</h3>
<dl><dt><a class="xref" href="c-api-data-structures.html" title="28.7.5 C API Data Structures">Section 28.7.5, “C API Data Structures”</a></dt><dd></dd><dt><a class="xref" href="charset-configuration.html" title="10.14 Character Set Configuration">Section 10.14, “Character Set Configuration”</a></dt><dd></dd><dt><a class="xref" href="charset-mysql.html" title="10.2 Character Sets and Collations in MySQL">Section 10.2, “Character Sets and Collations in MySQL”</a></dt><dd></dd><dt><a class="xref" href="data-dictionary-information-schema.html" title="14.5 INFORMATION_SCHEMA and Data Dictionary Integration">Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”</a></dt><dd></dd><dt><a class="xref" href="show-collation.html" title="13.7.6.4 SHOW COLLATION Syntax">Section 13.7.6.4, “SHOW COLLATION Syntax”</a></dt><dd></dd><dt><a class="xref" href="charset-binary-collations.html" title="10.8.5 The binary Collation Compared to _bin Collations">Section 10.8.5, “The binary Collation Compared to _bin Collations”</a></dt><dd></dd><dt><a class="xref" href="char.html" title="11.4.1 The CHAR and VARCHAR Types">Section 11.4.1, “The CHAR and VARCHAR Types”</a></dt><dd></dd><dt><a class="xref" href="collations-table.html" title="25.4 The INFORMATION_SCHEMA COLLATIONS Table">Section 25.4, “The INFORMATION_SCHEMA COLLATIONS Table”</a></dt><dd></dd><dt><a class="xref" href="charset-unicode-sets.html" title="10.10.1 Unicode Character Sets">Section 10.10.1, “Unicode Character Sets”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">COLUMN_PRIVILEGES</h3>
<dl><dt><a class="xref" href="column-privileges-table.html" title="25.7 The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table">Section 25.7, “The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">COLUMN_STATISTICS</h3>
<dl><dt><a class="xref" href="data-dictionary-information-schema.html" title="14.5 INFORMATION_SCHEMA and Data Dictionary Integration">Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”</a></dt><dd></dd><dt><a class="xref" href="optimizer-statistics.html" title="8.9.6 Optimizer Statistics">Section 8.9.6, “Optimizer Statistics”</a></dt><dd></dd><dt><a class="xref" href="column-statistics-table.html" title="25.8 The INFORMATION_SCHEMA COLUMN_STATISTICS Table">Section 25.8, “The INFORMATION_SCHEMA COLUMN_STATISTICS Table”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">COLUMNS</h3>
<dl><dt><a class="xref" href="data-dictionary-information-schema.html" title="14.5 INFORMATION_SCHEMA and Data Dictionary Integration">Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”</a></dt><dd></dd><dt><a class="xref" href="show-columns.html" title="13.7.6.5 SHOW COLUMNS Syntax">Section 13.7.6.5, “SHOW COLUMNS Syntax”</a></dt><dd></dd><dt><a class="xref" href="columns-table.html" title="25.6 The INFORMATION_SCHEMA COLUMNS Table">Section 25.6, “The INFORMATION_SCHEMA COLUMNS Table”</a></dt><dd></dd><dt><a class="xref" href="innodb-buffer-page-table.html" title="25.39.1 The INFORMATION_SCHEMA INNODB_BUFFER_PAGE Table">Section 25.39.1, “The INFORMATION_SCHEMA INNODB_BUFFER_PAGE Table”</a></dt><dd></dd><dt><a class="xref" href="innodb-buffer-page-lru-table.html" title="25.39.2 The INFORMATION_SCHEMA INNODB_BUFFER_PAGE_LRU Table">Section 25.39.2, “The INFORMATION_SCHEMA INNODB_BUFFER_PAGE_LRU Table”</a></dt><dd></dd><dt><a class="xref" href="innodb-buffer-pool-stats-table.html" title="25.39.3 The INFORMATION_SCHEMA INNODB_BUFFER_POOL_STATS Table">Section 25.39.3, “The INFORMATION_SCHEMA INNODB_BUFFER_POOL_STATS Table”</a></dt><dd></dd><dt><a class="xref" href="innodb-cached-indexes-table.html" title="25.39.4 The INFORMATION_SCHEMA INNODB_CACHED_INDEXES Table">Section 25.39.4, “The INFORMATION_SCHEMA INNODB_CACHED_INDEXES Table”</a></dt><dd></dd><dt><a class="xref" href="innodb-cmp-table.html" title="25.39.5 The INFORMATION_SCHEMA INNODB_CMP and INNODB_CMP_RESET Tables">Section 25.39.5, “The INFORMATION_SCHEMA INNODB_CMP and INNODB_CMP_RESET Tables”</a></dt><dd></dd><dt><a class="xref" href="innodb-cmp-per-index-table.html" title="25.39.7 The INFORMATION_SCHEMA INNODB_CMP_PER_INDEX and INNODB_CMP_PER_INDEX_RESET Tables">Section 25.39.7, “The INFORMATION_SCHEMA INNODB_CMP_PER_INDEX and
INNODB_CMP_PER_INDEX_RESET Tables”</a></dt><dd></dd><dt><a class="xref" href="innodb-cmpmem-table.html" title="25.39.6 The INFORMATION_SCHEMA INNODB_CMPMEM and INNODB_CMPMEM_RESET Tables">Section 25.39.6, “The INFORMATION_SCHEMA INNODB_CMPMEM and INNODB_CMPMEM_RESET Tables”</a></dt><dd></dd><dt><a class="xref" href="innodb-columns-table.html" title="25.39.8 The INFORMATION_SCHEMA INNODB_COLUMNS Table">Section 25.39.8, “The INFORMATION_SCHEMA INNODB_COLUMNS Table”</a></dt><dd></dd><dt><a class="xref" href="innodb-datafiles-table.html" title="25.39.9 The INFORMATION_SCHEMA INNODB_DATAFILES Table">Section 25.39.9, “The INFORMATION_SCHEMA INNODB_DATAFILES Table”</a></dt><dd></dd><dt><a class="xref" href="innodb-fields-table.html" title="25.39.10 The INFORMATION_SCHEMA INNODB_FIELDS Table">Section 25.39.10, “The INFORMATION_SCHEMA INNODB_FIELDS Table”</a></dt><dd></dd><dt><a class="xref" href="innodb-foreign-table.html" title="25.39.11 The INFORMATION_SCHEMA INNODB_FOREIGN Table">Section 25.39.11, “The INFORMATION_SCHEMA INNODB_FOREIGN Table”</a></dt><dd></dd><dt><a class="xref" href="innodb-foreign-cols-table.html" title="25.39.12 The INFORMATION_SCHEMA INNODB_FOREIGN_COLS Table">Section 25.39.12, “The INFORMATION_SCHEMA INNODB_FOREIGN_COLS Table”</a></dt><dd></dd><dt><a class="xref" href="innodb-ft-being-deleted-table.html" title="25.39.13 The INFORMATION_SCHEMA INNODB_FT_BEING_DELETED Table">Section 25.39.13, “The INFORMATION_SCHEMA INNODB_FT_BEING_DELETED Table”</a></dt><dd></dd><dt><a class="xref" href="innodb-ft-config-table.html" title="25.39.14 The INFORMATION_SCHEMA INNODB_FT_CONFIG Table">Section 25.39.14, “The INFORMATION_SCHEMA INNODB_FT_CONFIG Table”</a></dt><dd></dd><dt><a class="xref" href="innodb-ft-default-stopword-table.html" title="25.39.15 The INFORMATION_SCHEMA INNODB_FT_DEFAULT_STOPWORD Table">Section 25.39.15, “The INFORMATION_SCHEMA INNODB_FT_DEFAULT_STOPWORD Table”</a></dt><dd></dd><dt><a class="xref" href="innodb-ft-deleted-table.html" title="25.39.16 The INFORMATION_SCHEMA INNODB_FT_DELETED Table">Section 25.39.16, “The INFORMATION_SCHEMA INNODB_FT_DELETED Table”</a></dt><dd></dd><dt><a class="xref" href="innodb-ft-index-cache-table.html" title="25.39.17 The INFORMATION_SCHEMA INNODB_FT_INDEX_CACHE Table">Section 25.39.17, “The INFORMATION_SCHEMA INNODB_FT_INDEX_CACHE Table”</a></dt><dd></dd><dt><a class="xref" href="innodb-ft-index-table-table.html" title="25.39.18 The INFORMATION_SCHEMA INNODB_FT_INDEX_TABLE Table">Section 25.39.18, “The INFORMATION_SCHEMA INNODB_FT_INDEX_TABLE Table”</a></dt><dd></dd><dt><a class="xref" href="innodb-indexes-table.html" title="25.39.19 The INFORMATION_SCHEMA INNODB_INDEXES Table">Section 25.39.19, “The INFORMATION_SCHEMA INNODB_INDEXES Table”</a></dt><dd></dd><dt><a class="xref" href="innodb-metrics-table.html" title="25.39.22 The INFORMATION_SCHEMA INNODB_METRICS Table">Section 25.39.22, “The INFORMATION_SCHEMA INNODB_METRICS Table”</a></dt><dd></dd><dt><a class="xref" href="innodb-session-temp-tablespaces-table.html" title="25.39.23 The INFORMATION_SCHEMA INNODB_SESSION_TEMP_TABLESPACES Table">Section 25.39.23, “The INFORMATION_SCHEMA INNODB_SESSION_TEMP_TABLESPACES Table”</a></dt><dd></dd><dt><a class="xref" href="innodb-tables-table.html" title="25.39.24 The INFORMATION_SCHEMA INNODB_TABLES Table">Section 25.39.24, “The INFORMATION_SCHEMA INNODB_TABLES Table”</a></dt><dd></dd><dt><a class="xref" href="innodb-tablespaces-table.html" title="25.39.25 The INFORMATION_SCHEMA INNODB_TABLESPACES Table">Section 25.39.25, “The INFORMATION_SCHEMA INNODB_TABLESPACES Table”</a></dt><dd></dd><dt><a class="xref" href="innodb-tablespaces-brief-table.html" title="25.39.26 The INFORMATION_SCHEMA INNODB_TABLESPACES_BRIEF Table">Section 25.39.26, “The INFORMATION_SCHEMA INNODB_TABLESPACES_BRIEF Table”</a></dt><dd></dd><dt><a class="xref" href="innodb-tablestats-table.html" title="25.39.27 The INFORMATION_SCHEMA INNODB_TABLESTATS View">Section 25.39.27, “The INFORMATION_SCHEMA INNODB_TABLESTATS View”</a></dt><dd></dd><dt><a class="xref" href="innodb-temp-table-info-table.html" title="25.39.28 The INFORMATION_SCHEMA INNODB_TEMP_TABLE_INFO Table">Section 25.39.28, “The INFORMATION_SCHEMA INNODB_TEMP_TABLE_INFO Table”</a></dt><dd></dd><dt><a class="xref" href="innodb-trx-table.html" title="25.39.29 The INFORMATION_SCHEMA INNODB_TRX Table">Section 25.39.29, “The INFORMATION_SCHEMA INNODB_TRX Table”</a></dt><dd></dd><dt><a class="xref" href="innodb-virtual-table.html" title="25.39.30 The INFORMATION_SCHEMA INNODB_VIRTUAL Table">Section 25.39.30, “The INFORMATION_SCHEMA INNODB_VIRTUAL Table”</a></dt><dd></dd><dt><a class="xref" href="st-geometry-columns-table.html" title="25.27 The INFORMATION_SCHEMA ST_GEOMETRY_COLUMNS Table">Section 25.27, “The INFORMATION_SCHEMA ST_GEOMETRY_COLUMNS Table”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS</h3>
<dl><dt><a class="xref" href="connection-control-installation.html" title="6.4.2.1 Connection-Control Plugin Installation">Section 6.4.2.1, “Connection-Control Plugin Installation”</a></dt><dd></dd><dt><a class="xref" href="connection-control-variables.html" title="6.4.2.2 Connection-Control System and Status Variables">Section 6.4.2.2, “Connection-Control System and Status Variables”</a></dt><dd></dd><dt><a class="xref" href="connection-control.html" title="6.4.2 The Connection-Control Plugins">Section 6.4.2, “The Connection-Control Plugins”</a></dt><dd></dd><dt><a class="xref" href="connection-control-failed-login-attempts-table.html" title="25.41.1 The INFORMATION_SCHEMA CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS Table">Section 25.41.1, “The INFORMATION_SCHEMA CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS Table”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<a name="is-index-E"></a><h3 class="title">E</h3>
<p>[<a class="link" href="dynindex-is.html#is-index-top">index top</a>]</p><dl><dt></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ENGINES</h3>
<dl><dt><a class="xref" href="mysql-cluster-sql-statements.html" title="22.5.9 Quick Reference: NDB Cluster SQL Statements">Section 22.5.9, “Quick Reference: NDB Cluster SQL Statements”</a></dt><dd></dd><dt><a class="xref" href="server-system-variables.html" title="5.1.8 Server System Variables">Section 5.1.8, “Server System Variables”</a></dt><dd></dd><dt><a class="xref" href="show-engines.html" title="13.7.6.16 SHOW ENGINES Syntax">Section 13.7.6.16, “SHOW ENGINES Syntax”</a></dt><dd></dd><dt><a class="xref" href="engines-table.html" title="25.9 The INFORMATION_SCHEMA ENGINES Table">Section 25.9, “The INFORMATION_SCHEMA ENGINES Table”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">EVENTS</h3>
<dl><dt><a class="xref" href="events-metadata.html" title="24.4.4 Event Metadata">Section 24.4.4, “Event Metadata”</a></dt><dd></dd><dt><a class="xref" href="events-configuration.html" title="24.4.2 Event Scheduler Configuration">Section 24.4.2, “Event Scheduler Configuration”</a></dt><dd></dd><dt><a class="xref" href="data-dictionary-information-schema.html" title="14.5 INFORMATION_SCHEMA and Data Dictionary Integration">Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”</a></dt><dd></dd><dt><a class="xref" href="replication-features-invoked.html" title="17.4.1.16 Replication of Invoked Features">Section 17.4.1.16, “Replication of Invoked Features”</a></dt><dd></dd><dt><a class="xref" href="show-events.html" title="13.7.6.18 SHOW EVENTS Syntax">Section 13.7.6.18, “SHOW EVENTS Syntax”</a></dt><dd></dd><dt><a class="xref" href="events-table.html" title="25.10 The INFORMATION_SCHEMA EVENTS Table">Section 25.10, “The INFORMATION_SCHEMA EVENTS Table”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<a name="is-index-F"></a><h3 class="title">F</h3>
<p>[<a class="link" href="dynindex-is.html#is-index-top">index top</a>]</p><dl><dt></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">FILES</h3>
<dl><dt><a class="xref" href="data-dictionary-information-schema.html" title="14.5 INFORMATION_SCHEMA and Data Dictionary Integration">Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”</a></dt><dd></dd><dt><a class="xref" href="mysql-cluster-i_s-tables.html" title="22.5.11 INFORMATION_SCHEMA Tables for NDB Cluster">Section 22.5.11, “INFORMATION_SCHEMA Tables for NDB Cluster”</a></dt><dd></dd><dt><a class="xref" href="mysql-cluster-disk-data-objects.html" title="22.5.13.1 NDB Cluster Disk Data Objects">Section 22.5.13.1, “NDB Cluster Disk Data Objects”</a></dt><dd></dd><dt><a class="xref" href="mysql-cluster-ndbinfo.html" title="22.5.10 ndbinfo: The NDB Cluster Information Database">Section 22.5.10, “ndbinfo: The NDB Cluster Information Database”</a></dt><dd></dd><dt><a class="xref" href="files-table.html" title="25.11 The INFORMATION_SCHEMA FILES Table">Section 25.11, “The INFORMATION_SCHEMA FILES Table”</a></dt><dd></dd><dt><a class="xref" href="innodb-datafiles-table.html" title="25.39.9 The INFORMATION_SCHEMA INNODB_DATAFILES Table">Section 25.39.9, “The INFORMATION_SCHEMA INNODB_DATAFILES Table”</a></dt><dd></dd><dt><a class="xref" href="innodb-tablespaces-table.html" title="25.39.25 The INFORMATION_SCHEMA INNODB_TABLESPACES Table">Section 25.39.25, “The INFORMATION_SCHEMA INNODB_TABLESPACES Table”</a></dt><dd></dd><dt><a class="xref" href="tablespaces-table.html" title="25.31 The INFORMATION_SCHEMA TABLESPACES Table">Section 25.31, “The INFORMATION_SCHEMA TABLESPACES Table”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<a name="is-index-G"></a><h3 class="title">G</h3>
<p>[<a class="link" href="dynindex-is.html#is-index-top">index top</a>]</p><dl><dt></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">GLOBAL_STATUS</h3>
<dl><dt><a class="xref" href="mysql-cluster-management.html" title="22.5 Management of NDB Cluster">Section 22.5, “Management of NDB Cluster”</a></dt><dd></dd><dt><a class="xref" href="mysql-cluster-ndb-api-statistics.html" title="22.5.17 NDB API Statistics Counters and Variables">Section 22.5.17, “NDB API Statistics Counters and Variables”</a></dt><dd></dd><dt><a class="xref" href="mysql-cluster-replication.html" title="22.6 NDB Cluster Replication">Section 22.6, “NDB Cluster Replication”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<a name="is-index-I"></a><h3 class="title">I</h3>
<p>[<a class="link" href="dynindex-is.html#is-index-top">index top</a>]</p><dl><dt></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA</h3>
<dl><dt><a class="xref" href="upgrading-from-previous-series.html" title="2.11.4 Changes in MySQL 8.0">Section 2.11.4, “Changes in MySQL 8.0”</a></dt><dd></dd><dt><a class="xref" href="data-dictionary-schema.html" title="14.1 Data Dictionary Schema">Section 14.1, “Data Dictionary Schema”</a></dt><dd></dd><dt><a class="xref" href="data-dictionary-information-schema.html" title="14.5 INFORMATION_SCHEMA and Data Dictionary Integration">Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”</a></dt><dd></dd><dt><a class="xref" href="mysql-cluster-i_s-tables.html" title="22.5.11 INFORMATION_SCHEMA Tables for NDB Cluster">Section 22.5.11, “INFORMATION_SCHEMA Tables for NDB Cluster”</a></dt><dd></dd><dt><a class="xref" href="innodb-information-schema.html" title="15.14 InnoDB INFORMATION_SCHEMA Tables">Section 15.14, “InnoDB INFORMATION_SCHEMA Tables”</a></dt><dd></dd><dt><a class="xref" href="data-dictionary.html" title="Chapter 14 MySQL Data Dictionary">Chapter 14, <i>MySQL Data Dictionary</i></a></dt><dd></dd><dt><a class="xref" href="glossary.html" title="MySQL Glossary">MySQL Glossary</a></dt><dd></dd><dt><a class="xref" href="reserved-users.html" title="6.2.9 Reserved Accounts">Section 6.2.9, “Reserved Accounts”</a></dt><dd></dd><dt><a class="xref" href="server-error-reference.html" title="B.3.1 Server Error Message Reference">Section B.3.1, “Server Error Message Reference”</a></dt><dd></dd><dt><a class="xref" href="data-directory.html" title="5.2 The MySQL Data Directory">Section 5.2, “The MySQL Data Directory”</a></dt><dd></dd><dt><a class="xref" href="sys-schema-usage.html" title="27.2 Using the sys Schema">Section 27.2, “Using the sys Schema”</a></dt><dd></dd><dt><a class="xref" href="mysql-nutshell.html" title="1.4 What Is New in MySQL 8.0">Section 1.4, “What Is New in MySQL 8.0”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.CHARACTER_SETS</h3>
<dl><dt><a class="xref" href="faqs-cjk.html" title="A.11 MySQL 8.0 FAQ: MySQL Chinese, Japanese, and Korean Character Sets">Section A.11, “MySQL 8.0 FAQ: MySQL Chinese, Japanese, and Korean
Character Sets”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.COLLATIONS</h3>
<dl><dt><a class="xref" href="adding-collation-choosing-id.html" title="10.13.2 Choosing a Collation ID">Section 10.13.2, “Choosing a Collation ID”</a></dt><dd></dd><dt><a class="xref" href="optimizer-statistics.html" title="8.9.6 Optimizer Statistics">Section 8.9.6, “Optimizer Statistics”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.COLUMN_STATISTICS</h3>
<dl><dt><a class="xref" href="optimizer-statistics.html" title="8.9.6 Optimizer Statistics">Section 8.9.6, “Optimizer Statistics”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.COLUMNS</h3>
<dl><dt><a class="xref" href="mysql-cluster-programs-ndb-index-stat.html" title="22.4.14 ndb_index_stat — NDB Index Statistics Utility">Section 22.4.14, “<span class="command"><strong>ndb_index_stat</strong></span> — NDB Index Statistics Utility”</a></dt><dd></dd><dt><a class="xref" href="performance-schema-quick-start.html" title="26.1 Performance Schema Quick Start">Section 26.1, “Performance Schema Quick Start”</a></dt><dd></dd><dt><a class="xref" href="server-system-variables.html" title="5.1.8 Server System Variables">Section 5.1.8, “Server System Variables”</a></dt><dd></dd><dt><a class="xref" href="upgrade-binary-package.html" title="2.11.6 Upgrading MySQL Binary or Package-based Installations on Unix/Linux">Section 2.11.6, “Upgrading MySQL Binary or Package-based Installations on Unix/Linux”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.ENGINES</h3>
<dl><dt><a class="xref" href="performance-schema-quick-start.html" title="26.1 Performance Schema Quick Start">Section 26.1, “Performance Schema Quick Start”</a></dt><dd></dd><dt><a class="xref" href="mysql-cluster-sql-statements.html" title="22.5.9 Quick Reference: NDB Cluster SQL Statements">Section 22.5.9, “Quick Reference: NDB Cluster SQL Statements”</a></dt><dd></dd><dt><a class="xref" href="innodb-check-availability.html" title="15.1.3 Verifying that InnoDB is the Default Storage Engine">Section 15.1.3, “Verifying that InnoDB is the Default Storage Engine”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.EVENTS</h3>
<dl><dt><a class="xref" href="events-metadata.html" title="24.4.4 Event Metadata">Section 24.4.4, “Event Metadata”</a></dt><dd></dd><dt><a class="xref" href="replication-features-invoked.html" title="17.4.1.16 Replication of Invoked Features">Section 17.4.1.16, “Replication of Invoked Features”</a></dt><dd></dd><dt><a class="xref" href="stored-program-restrictions.html" title="C.1 Restrictions on Stored Programs">Section C.1, “Restrictions on Stored Programs”</a></dt><dd></dd><dt><a class="xref" href="events-privileges.html" title="24.4.6 The Event Scheduler and MySQL Privileges">Section 24.4.6, “The Event Scheduler and MySQL Privileges”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.FILES</h3>
<dl><dt><a class="xref" href="alter-logfile-group.html" title="13.1.6 ALTER LOGFILE GROUP Syntax">Section 13.1.6, “ALTER LOGFILE GROUP Syntax”</a></dt><dd></dd><dt><a class="xref" href="alter-tablespace.html" title="13.1.10 ALTER TABLESPACE Syntax">Section 13.1.10, “ALTER TABLESPACE Syntax”</a></dt><dd></dd><dt><a class="xref" href="upgrading-from-previous-series.html" title="2.11.4 Changes in MySQL 8.0">Section 2.11.4, “Changes in MySQL 8.0”</a></dt><dd></dd><dt><a class="xref" href="create-logfile-group.html" title="13.1.16 CREATE LOGFILE GROUP Syntax">Section 13.1.16, “CREATE LOGFILE GROUP Syntax”</a></dt><dd></dd><dt><a class="xref" href="create-tablespace.html" title="13.1.21 CREATE TABLESPACE Syntax">Section 13.1.21, “CREATE TABLESPACE Syntax”</a></dt><dd></dd><dt><a class="xref" href="innodb-moving-data-files-offline.html" title="15.6.3.8 Moving Tablespace Files While the Server is Offline">Section 15.6.3.8, “Moving Tablespace Files While the Server is Offline”</a></dt><dd></dd><dt><a class="xref" href="mysql-cluster-disk-data-storage-requirements.html" title="22.5.13.3 NDB Cluster Disk Data Storage Requirements">Section 22.5.13.3, “NDB Cluster Disk Data Storage Requirements”</a></dt><dd></dd><dt><a class="xref" href="mysql-cluster-programs-ndb-desc.html" title="22.4.9 ndb_desc — Describe NDB Tables">Section 22.4.9, “<span class="command"><strong>ndb_desc</strong></span> — Describe NDB Tables”</a></dt><dd></dd><dt><a class="xref" href="innodb-information-schema-files-table.html" title="15.14.8 Retrieving InnoDB Tablespace Metadata from INFORMATION_SCHEMA.FILES">Section 15.14.8, “Retrieving InnoDB Tablespace Metadata from INFORMATION_SCHEMA.FILES”</a></dt><dd></dd><dt><a class="xref" href="innodb-temporary-tablespace.html" title="15.6.3.5 Temporary Tablespaces">Section 15.6.3.5, “Temporary Tablespaces”</a></dt><dd></dd><dt><a class="xref" href="innodb-undo-tablespaces.html" title="15.6.3.4 Undo Tablespaces">Section 15.6.3.4, “Undo Tablespaces”</a></dt><dd></dd><dt><a class="xref" href="mysql-cluster-what-is-new.html" title="22.1.4 What is New in NDB Cluster">Section 22.1.4, “What is New in NDB Cluster”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.GLOBAL_STATUS</h3>
<dl><dt><a class="xref" href="mysql-cluster-ndb-api-statistics.html" title="22.5.17 NDB API Statistics Counters and Variables">Section 22.5.17, “NDB API Statistics Counters and Variables”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.INNODB_BUFFER_PAGE</h3>
<dl><dt><a class="xref" href="innodb-change-buffer.html" title="15.5.2 Change Buffer">Section 15.5.2, “Change Buffer”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.INNODB_CACHED_INDEXES</h3>
<dl><dt><a class="xref" href="mysql-nutshell.html" title="1.4 What Is New in MySQL 8.0">Section 1.4, “What Is New in MySQL 8.0”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.INNODB_CMP</h3>
<dl><dt><a class="xref" href="glossary.html" title="MySQL Glossary">MySQL Glossary</a></dt><dd></dd><dt><a class="xref" href="innodb-compression-tuning.html" title="15.9.1.3 Tuning Compression for InnoDB Tables">Section 15.9.1.3, “Tuning Compression for InnoDB Tables”</a></dt><dd></dd><dt><a class="xref" href="innodb-information-schema-examples-compression-sect.html" title="15.14.1.3 Using the Compression Information Schema Tables">Section 15.14.1.3, “Using the Compression Information Schema Tables”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.INNODB_CMP_PER_INDEX</h3>
<dl><dt><a class="xref" href="innodb-parameters.html" title="15.13 InnoDB Startup Options and System Variables">Section 15.13, “InnoDB Startup Options and System Variables”</a></dt><dd></dd><dt><a class="xref" href="innodb-compression-tuning.html" title="15.9.1.3 Tuning Compression for InnoDB Tables">Section 15.9.1.3, “Tuning Compression for InnoDB Tables”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.INNODB_CMPMEM</h3>
<dl><dt><a class="xref" href="innodb-information-schema-examples-compression-sect.html" title="15.14.1.3 Using the Compression Information Schema Tables">Section 15.14.1.3, “Using the Compression Information Schema Tables”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.INNODB_COLUMNS</h3>
<dl><dt><a class="xref" href="innodb-online-ddl-operations.html" title="15.12.1 Online DDL Operations">Section 15.12.1, “Online DDL Operations”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.INNODB_DATAFILES</h3>
<dl><dt><a class="xref" href="upgrading-from-previous-series.html" title="2.11.4 Changes in MySQL 8.0">Section 2.11.4, “Changes in MySQL 8.0”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.INNODB_FT_CONFIG</h3>
<dl><dt><a class="xref" href="innodb-fulltext-index.html" title="15.6.2.4 InnoDB FULLTEXT Indexes">Section 15.6.2.4, “InnoDB FULLTEXT Indexes”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.INNODB_FT_DEFAULT_STOPWORD</h3>
<dl><dt><a class="xref" href="fulltext-stopwords.html" title="12.9.4 Full-Text Stopwords">Section 12.9.4, “Full-Text Stopwords”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.INNODB_FT_INDEX_CACHE</h3>
<dl><dt><a class="xref" href="innodb-fulltext-index.html" title="15.6.2.4 InnoDB FULLTEXT Indexes">Section 15.6.2.4, “InnoDB FULLTEXT Indexes”</a></dt><dd></dd><dt><a class="xref" href="fulltext-search-mecab.html" title="12.9.9 MeCab Full-Text Parser Plugin">Section 12.9.9, “MeCab Full-Text Parser Plugin”</a></dt><dd></dd><dt><a class="xref" href="fulltext-search-ngram.html" title="12.9.8 ngram Full-Text Parser">Section 12.9.8, “ngram Full-Text Parser”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.INNODB_FT_INDEX_TABLE</h3>
<dl><dt><a class="xref" href="fulltext-stopwords.html" title="12.9.4 Full-Text Stopwords">Section 12.9.4, “Full-Text Stopwords”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.INNODB_INDEXES</h3>
<dl><dt><a class="xref" href="innodb-fulltext-index.html" title="15.6.2.4 InnoDB FULLTEXT Indexes">Section 15.6.2.4, “InnoDB FULLTEXT Indexes”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.INNODB_METRICS</h3>
<dl><dt><a class="xref" href="innodb-change-buffer.html" title="15.5.2 Change Buffer">Section 15.5.2, “Change Buffer”</a></dt><dd></dd><dt><a class="xref" href="innodb-information-schema-metrics-table.html" title="15.14.6 InnoDB INFORMATION_SCHEMA Metrics Table">Section 15.14.6, “InnoDB INFORMATION_SCHEMA Metrics Table”</a></dt><dd></dd><dt><a class="xref" href="innodb-parameters.html" title="15.13 InnoDB Startup Options and System Variables">Section 15.13, “InnoDB Startup Options and System Variables”</a></dt><dd></dd><dt><a class="xref" href="innodb-undo-tablespaces.html" title="15.6.3.4 Undo Tablespaces">Section 15.6.3.4, “Undo Tablespaces”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.INNODB_TABLES</h3>
<dl><dt><a class="xref" href="partitioning-management-exchange.html" title="23.3.3 Exchanging Partitions and Subpartitions with Tables">Section 23.3.3, “Exchanging Partitions and Subpartitions with Tables”</a></dt><dd></dd><dt><a class="xref" href="innodb-information-schema-system-tables.html" title="15.14.3 InnoDB INFORMATION_SCHEMA Schema Object Tables">Section 15.14.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”</a></dt><dd></dd><dt><a class="xref" href="innodb-row-format.html" title="15.10 InnoDB Row Formats">Section 15.10, “InnoDB Row Formats”</a></dt><dd></dd><dt><a class="xref" href="innodb-online-ddl-operations.html" title="15.12.1 Online DDL Operations">Section 15.12.1, “Online DDL Operations”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.INNODB_TABLESPACES</h3>
<dl><dt><a class="xref" href="innodb-tablespace-encryption.html" title="15.6.3.9 InnoDB Data-at-Rest Encryption">Section 15.6.3.9, “InnoDB Data-at-Rest Encryption”</a></dt><dd></dd><dt><a class="xref" href="innodb-information-schema-system-tables.html" title="15.14.3 InnoDB INFORMATION_SCHEMA Schema Object Tables">Section 15.14.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”</a></dt><dd></dd><dt><a class="xref" href="innodb-page-compression.html" title="15.9.2 InnoDB Page Compression">Section 15.9.2, “InnoDB Page Compression”</a></dt><dd></dd><dt><a class="xref" href="innodb-undo-tablespaces.html" title="15.6.3.4 Undo Tablespaces">Section 15.6.3.4, “Undo Tablespaces”</a></dt><dd></dd><dt><a class="xref" href="mysql-nutshell.html" title="1.4 What Is New in MySQL 8.0">Section 1.4, “What Is New in MySQL 8.0”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.INNODB_TABLESPACES_BRIEF</h3>
<dl><dt><a class="xref" href="mysql-nutshell.html" title="1.4 What Is New in MySQL 8.0">Section 1.4, “What Is New in MySQL 8.0”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.INNODB_TABLESTATS</h3>
<dl><dt><a class="xref" href="analyze-table.html" title="13.7.3.1 ANALYZE TABLE Syntax">Section 13.7.3.1, “ANALYZE TABLE Syntax”</a></dt><dd></dd><dt><a class="xref" href="innodb-information-schema-system-tables.html" title="15.14.3 InnoDB INFORMATION_SCHEMA Schema Object Tables">Section 15.14.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.INNODB_TEMP_TABLE_INFO</h3>
<dl><dt><a class="xref" href="innodb-temporary-tablespace.html" title="15.6.3.5 Temporary Tablespaces">Section 15.6.3.5, “Temporary Tablespaces”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.INNODB_TRX</h3>
<dl><dt><a class="xref" href="innodb-parameters.html" title="15.13 InnoDB Startup Options and System Variables">Section 15.13, “InnoDB Startup Options and System Variables”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.KEY_COLUMN_USAGE</h3>
<dl><dt><a class="xref" href="constraint-foreign-key.html" title="1.8.3.2 FOREIGN KEY Constraints">Section 1.8.3.2, “FOREIGN KEY Constraints”</a></dt><dd></dd><dt><a class="xref" href="create-table-foreign-keys.html" title="13.1.20.6 Using FOREIGN KEY Constraints">Section 13.1.20.6, “Using FOREIGN KEY Constraints”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.OPTIMIZER_TRACE</h3>
<dl><dt><a class="xref" href="range-optimization.html" title="8.2.1.2 Range Optimization">Section 8.2.1.2, “Range Optimization”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.PARTITIONS</h3>
<dl><dt><a class="xref" href="partitioning-management-exchange.html" title="23.3.3 Exchanging Partitions and Subpartitions with Tables">Section 23.3.3, “Exchanging Partitions and Subpartitions with Tables”</a></dt><dd></dd><dt><a class="xref" href="partitioning-handling-nulls.html" title="23.2.7 How MySQL Partitioning Handles NULL">Section 23.2.7, “How MySQL Partitioning Handles NULL”</a></dt><dd></dd><dt><a class="xref" href="partitioning-key.html" title="23.2.5 KEY Partitioning">Section 23.2.5, “KEY Partitioning”</a></dt><dd></dd><dt><a class="xref" href="partitioning-info.html" title="23.3.5 Obtaining Information About Partitions">Section 23.3.5, “Obtaining Information About Partitions”</a></dt><dd></dd><dt><a class="xref" href="partitioning-columns-range.html" title="23.2.3.1 RANGE COLUMNS partitioning">Section 23.2.3.1, “RANGE COLUMNS partitioning”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.PLUGINS</h3>
<dl><dt><a class="xref" href="connection-control-installation.html" title="6.4.2.1 Connection-Control Plugin Installation">Section 6.4.2.1, “Connection-Control Plugin Installation”</a></dt><dd></dd><dt><a class="xref" href="innodb-tablespace-encryption.html" title="15.6.3.9 InnoDB Data-at-Rest Encryption">Section 15.6.3.9, “InnoDB Data-at-Rest Encryption”</a></dt><dd></dd><dt><a class="xref" href="plugin-loading.html" title="5.6.1 Installing and Uninstalling Plugins">Section 5.6.1, “Installing and Uninstalling Plugins”</a></dt><dd></dd><dt><a class="xref" href="ddl-rewriter-installation.html" title="5.6.5.1 Installing or Uninstalling ddl_rewriter">Section 5.6.5.1, “Installing or Uninstalling ddl_rewriter”</a></dt><dd></dd><dt><a class="xref" href="audit-log-installation.html" title="6.4.5.2 Installing or Uninstalling MySQL Enterprise Audit">Section 6.4.5.2, “Installing or Uninstalling MySQL Enterprise Audit”</a></dt><dd></dd><dt><a class="xref" href="keyring-installation.html" title="6.4.4.1 Keyring Plugin Installation">Section 6.4.4.1, “Keyring Plugin Installation”</a></dt><dd></dd><dt><a class="xref" href="ldap-pluggable-authentication.html" title="6.4.1.7 LDAP Pluggable Authentication">Section 6.4.1.7, “LDAP Pluggable Authentication”</a></dt><dd></dd><dt><a class="xref" href="faqs-storage-engines.html" title="A.2 MySQL 8.0 FAQ: Storage Engines">Section A.2, “MySQL 8.0 FAQ: Storage Engines”</a></dt><dd></dd><dt><a class="xref" href="no-login-pluggable-authentication.html" title="6.4.1.8 No-Login Pluggable Authentication">Section 6.4.1.8, “No-Login Pluggable Authentication”</a></dt><dd></dd><dt><a class="xref" href="obtaining-plugin-information.html" title="5.6.2 Obtaining Server Plugin Information">Section 5.6.2, “Obtaining Server Plugin Information”</a></dt><dd></dd><dt><a class="xref" href="pam-pluggable-authentication.html" title="6.4.1.5 PAM Pluggable Authentication">Section 6.4.1.5, “PAM Pluggable Authentication”</a></dt><dd></dd><dt><a class="xref" href="plugin-api-characteristics.html" title="29.2.2 Plugin API Characteristics">Section 29.2.2, “Plugin API Characteristics”</a></dt><dd></dd><dt><a class="xref" href="plugin-api-components.html" title="29.2.3 Plugin API Components">Section 29.2.3, “Plugin API Components”</a></dt><dd></dd><dt><a class="xref" href="replication-semisync-installation.html" title="17.3.11.2 Semisynchronous Replication Installation and Configuration">Section 17.3.11.2, “Semisynchronous Replication Installation and Configuration”</a></dt><dd></dd><dt><a class="xref" href="plugin-data-structures.html#server-plugin-descriptors" title="29.2.4.2.1 Server Plugin Library and Plugin Descriptors">Section 29.2.4.2.1, “Server Plugin Library and Plugin Descriptors”</a></dt><dd></dd><dt><a class="xref" href="socket-pluggable-authentication.html" title="6.4.1.9 Socket Peer-Credential Pluggable Authentication">Section 6.4.1.9, “Socket Peer-Credential Pluggable Authentication”</a></dt><dd></dd><dt><a class="xref" href="test-pluggable-authentication.html" title="6.4.1.10 Test Pluggable Authentication">Section 6.4.1.10, “Test Pluggable Authentication”</a></dt><dd></dd><dt><a class="xref" href="thread-pool-installation.html" title="5.6.3.2 Thread Pool Installation">Section 5.6.3.2, “Thread Pool Installation”</a></dt><dd></dd><dt><a class="xref" href="mysql-nutshell.html" title="1.4 What Is New in MySQL 8.0">Section 1.4, “What Is New in MySQL 8.0”</a></dt><dd></dd><dt><a class="xref" href="windows-pluggable-authentication.html" title="6.4.1.6 Windows Pluggable Authentication">Section 6.4.1.6, “Windows Pluggable Authentication”</a></dt><dd></dd><dt><a class="xref" href="writing-audit-plugins.html" title="29.2.4.8 Writing Audit Plugins">Section 29.2.4.8, “Writing Audit Plugins”</a></dt><dd></dd><dt><a class="xref" href="writing-daemon-plugins.html" title="29.2.4.5 Writing Daemon Plugins">Section 29.2.4.5, “Writing Daemon Plugins”</a></dt><dd></dd><dt><a class="xref" href="writing-full-text-plugins.html" title="29.2.4.4 Writing Full-Text Parser Plugins">Section 29.2.4.4, “Writing Full-Text Parser Plugins”</a></dt><dd></dd><dt><a class="xref" href="writing-information-schema-plugins.html" title="29.2.4.6 Writing INFORMATION_SCHEMA Plugins">Section 29.2.4.6, “Writing INFORMATION_SCHEMA Plugins”</a></dt><dd></dd><dt><a class="xref" href="writing-keyring-plugins.html" title="29.2.4.12 Writing Keyring Plugins">Section 29.2.4.12, “Writing Keyring Plugins”</a></dt><dd></dd><dt><a class="xref" href="writing-password-validation-plugins.html" title="29.2.4.10 Writing Password-Validation Plugins">Section 29.2.4.10, “Writing Password-Validation Plugins”</a></dt><dd></dd><dt><a class="xref" href="writing-authentication-plugins.html#writing-authentication-plugins-server-side" title="29.2.4.9.1 Writing the Server-Side Authentication Plugin">Section 29.2.4.9.1, “Writing the Server-Side Authentication Plugin”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.PROCESSLIST</h3>
<dl><dt><a class="xref" href="thread-information.html" title="8.14 Examining Thread Information">Section 8.14, “Examining Thread Information”</a></dt><dd></dd><dt><a class="xref" href="information-functions.html" title="12.15 Information Functions">Section 12.15, “Information Functions”</a></dt><dd></dd><dt><a class="xref" href="performance-schema-instrument-naming.html" title="26.6 Performance Schema Instrument Naming Conventions">Section 26.6, “Performance Schema Instrument Naming Conventions”</a></dt><dd></dd><dt><a class="xref" href="performance-schema-stage-tables.html" title="26.12.5 Performance Schema Stage Event Tables">Section 26.12.5, “Performance Schema Stage Event Tables”</a></dt><dd></dd><dt><a class="xref" href="threads-table.html" title="26.12.17.5 The threads Table">Section 26.12.17.5, “The threads Table”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.RESOURCE_GROUPS</h3>
<dl><dt><a class="xref" href="resource-groups.html" title="8.12.5 Resource Groups">Section 8.12.5, “Resource Groups”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.ROUTINES</h3>
<dl><dt><a class="xref" href="faqs-stored-procs.html" title="A.4 MySQL 8.0 FAQ: Stored Procedures and Functions">Section A.4, “MySQL 8.0 FAQ: Stored Procedures and Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.SCHEMATA</h3>
<dl><dt><a class="xref" href="charset-database.html" title="10.3.3 Database Character Set and Collation">Section 10.3.3, “Database Character Set and Collation”</a></dt><dd></dd><dt><a class="xref" href="innodb-tablespace-encryption.html" title="15.6.3.9 InnoDB Data-at-Rest Encryption">Section 15.6.3.9, “InnoDB Data-at-Rest Encryption”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.SESSION_STATUS</h3>
<dl><dt><a class="xref" href="mysql-cluster-ndb-api-statistics.html" title="22.5.17 NDB API Statistics Counters and Variables">Section 22.5.17, “NDB API Statistics Counters and Variables”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.STATISTICS</h3>
<dl><dt><a class="xref" href="innodb-statistics-estimation.html" title="15.8.10.2 Configuring Non-Persistent Optimizer Statistics Parameters">Section 15.8.10.2, “Configuring Non-Persistent Optimizer Statistics Parameters”</a></dt><dd></dd><dt><a class="xref" href="index-hints.html" title="8.9.4 Index Hints">Section 8.9.4, “Index Hints”</a></dt><dd></dd><dt><a class="xref" href="innodb-parameters.html" title="15.13 InnoDB Startup Options and System Variables">Section 15.13, “InnoDB Startup Options and System Variables”</a></dt><dd></dd><dt><a class="xref" href="invisible-indexes.html" title="8.3.12 Invisible Indexes">Section 8.3.12, “Invisible Indexes”</a></dt><dd></dd><dt><a class="xref" href="mysql-cluster-programs-ndb-index-stat.html" title="22.4.14 ndb_index_stat — NDB Index Statistics Utility">Section 22.4.14, “<span class="command"><strong>ndb_index_stat</strong></span> — NDB Index Statistics Utility”</a></dt><dd></dd><dt><a class="xref" href="system-schema.html" title="5.3 The mysql System Schema">Section 5.3, “The mysql System Schema”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.TABLE_CONSTRAINTS</h3>
<dl><dt><a class="xref" href="innodb-online-ddl-operations.html" title="15.12.1 Online DDL Operations">Section 15.12.1, “Online DDL Operations”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.TABLES</h3>
<dl><dt><a class="xref" href="mysql-cluster-online-add-node-example.html" title="22.5.15.3 Adding NDB Cluster Data Nodes Online: Detailed Example">Section 22.5.15.3, “Adding NDB Cluster Data Nodes Online: Detailed Example”</a></dt><dd></dd><dt><a class="xref" href="alter-table.html" title="13.1.9 ALTER TABLE Syntax">Section 13.1.9, “ALTER TABLE Syntax”</a></dt><dd></dd><dt><a class="xref" href="innodb-statistics-estimation.html" title="15.8.10.2 Configuring Non-Persistent Optimizer Statistics Parameters">Section 15.8.10.2, “Configuring Non-Persistent Optimizer Statistics Parameters”</a></dt><dd></dd><dt><a class="xref" href="innodb-tablespace-encryption.html" title="15.6.3.9 InnoDB Data-at-Rest Encryption">Section 15.6.3.9, “InnoDB Data-at-Rest Encryption”</a></dt><dd></dd><dt><a class="xref" href="innodb-parameters.html" title="15.13 InnoDB Startup Options and System Variables">Section 15.13, “InnoDB Startup Options and System Variables”</a></dt><dd></dd><dt><a class="xref" href="data-dictionary-file-removal.html" title="14.2 Removal of File-based Metadata Storage">Section 14.2, “Removal of File-based Metadata Storage”</a></dt><dd></dd><dt><a class="xref" href="sys-diagnostics.html" title="27.4.4.2 The diagnostics() Procedure">Section 27.4.4.2, “The diagnostics() Procedure”</a></dt><dd></dd><dt><a class="xref" href="sys-sys-config.html" title="27.4.2.1 The sys_config Table">Section 27.4.2.1, “The sys_config Table”</a></dt><dd></dd><dt><a class="xref" href="thread-pool-installation.html" title="5.6.3.2 Thread Pool Installation">Section 5.6.3.2, “Thread Pool Installation”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.TRIGGERS</h3>
<dl><dt><a class="xref" href="faqs-triggers.html" title="A.5 MySQL 8.0 FAQ: Triggers">Section A.5, “MySQL 8.0 FAQ: Triggers”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.VIEWS</h3>
<dl><dt><a class="xref" href="view-updatability.html" title="24.5.3 Updatable and Insertable Views">Section 24.5.3, “Updatable and Insertable Views”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INNODB_BUFFER_PAGE</h3>
<dl><dt><a class="xref" href="innodb-change-buffer.html" title="15.5.2 Change Buffer">Section 15.5.2, “Change Buffer”</a></dt><dd></dd><dt><a class="xref" href="innodb-information-schema-buffer-pool-tables.html" title="15.14.5 InnoDB INFORMATION_SCHEMA Buffer Pool Tables">Section 15.14.5, “InnoDB INFORMATION_SCHEMA Buffer Pool Tables”</a></dt><dd></dd><dt><a class="xref" href="sys-schema-prerequisites.html" title="27.1 Prerequisites for Using the sys Schema">Section 27.1, “Prerequisites for Using the sys Schema”</a></dt><dd></dd><dt><a class="xref" href="innodb-buffer-page-table.html" title="25.39.1 The INFORMATION_SCHEMA INNODB_BUFFER_PAGE Table">Section 25.39.1, “The INFORMATION_SCHEMA INNODB_BUFFER_PAGE Table”</a></dt><dd></dd><dt><a class="xref" href="innodb-buffer-page-lru-table.html" title="25.39.2 The INFORMATION_SCHEMA INNODB_BUFFER_PAGE_LRU Table">Section 25.39.2, “The INFORMATION_SCHEMA INNODB_BUFFER_PAGE_LRU Table”</a></dt><dd></dd><dt><a class="xref" href="sys-innodb-buffer-stats-by-schema.html" title="27.4.3.7 The innodb_buffer_stats_by_schema and x$innodb_buffer_stats_by_schema Views">Section 27.4.3.7, “The innodb_buffer_stats_by_schema and x$innodb_buffer_stats_by_schema
          Views”</a></dt><dd></dd><dt><a class="xref" href="sys-innodb-buffer-stats-by-table.html" title="27.4.3.8 The innodb_buffer_stats_by_table and x$innodb_buffer_stats_by_table Views">Section 27.4.3.8, “The innodb_buffer_stats_by_table and x$innodb_buffer_stats_by_table
Views”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INNODB_BUFFER_PAGE_LRU</h3>
<dl><dt><a class="xref" href="innodb-information-schema-buffer-pool-tables.html" title="15.14.5 InnoDB INFORMATION_SCHEMA Buffer Pool Tables">Section 15.14.5, “InnoDB INFORMATION_SCHEMA Buffer Pool Tables”</a></dt><dd></dd><dt><a class="xref" href="innodb-preload-buffer-pool.html" title="15.8.3.7 Saving and Restoring the Buffer Pool State">Section 15.8.3.7, “Saving and Restoring the Buffer Pool State”</a></dt><dd></dd><dt><a class="xref" href="innodb-buffer-page-lru-table.html" title="25.39.2 The INFORMATION_SCHEMA INNODB_BUFFER_PAGE_LRU Table">Section 25.39.2, “The INFORMATION_SCHEMA INNODB_BUFFER_PAGE_LRU Table”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INNODB_BUFFER_POOL_STATS</h3>
<dl><dt><a class="xref" href="innodb-buffer-pool.html" title="15.5.1 Buffer Pool">Section 15.5.1, “Buffer Pool”</a></dt><dd></dd><dt><a class="xref" href="innodb-information-schema-buffer-pool-tables.html" title="15.14.5 InnoDB INFORMATION_SCHEMA Buffer Pool Tables">Section 15.14.5, “InnoDB INFORMATION_SCHEMA Buffer Pool Tables”</a></dt><dd></dd><dt><a class="xref" href="innodb-buffer-pool-stats-table.html" title="25.39.3 The INFORMATION_SCHEMA INNODB_BUFFER_POOL_STATS Table">Section 25.39.3, “The INFORMATION_SCHEMA INNODB_BUFFER_POOL_STATS Table”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INNODB_CACHED_INDEXES</h3>
<dl><dt><a class="xref" href="innodb-cached-indexes-table.html" title="25.39.4 The INFORMATION_SCHEMA INNODB_CACHED_INDEXES Table">Section 25.39.4, “The INFORMATION_SCHEMA INNODB_CACHED_INDEXES Table”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INNODB_CMP</h3>
<dl><dt><a class="xref" href="innodb-information-schema-compression-tables.html" title="15.14.1 InnoDB INFORMATION_SCHEMA Tables about Compression">Section 15.14.1, “InnoDB INFORMATION_SCHEMA Tables about Compression”</a></dt><dd></dd><dt><a class="xref" href="innodb-information-schema-innodb_cmp.html" title="15.14.1.1 INNODB_CMP and INNODB_CMP_RESET">Section 15.14.1.1, “INNODB_CMP and INNODB_CMP_RESET”</a></dt><dd></dd><dt><a class="xref" href="innodb-information-schema-innodb_cmpmem.html" title="15.14.1.2 INNODB_CMPMEM and INNODB_CMPMEM_RESET">Section 15.14.1.2, “INNODB_CMPMEM and INNODB_CMPMEM_RESET”</a></dt><dd></dd><dt><a class="xref" href="innodb-compression-tuning-monitoring.html" title="15.9.1.4 Monitoring InnoDB Table Compression at Runtime">Section 15.9.1.4, “Monitoring InnoDB Table Compression at Runtime”</a></dt><dd></dd><dt><a class="xref" href="innodb-cmp-table.html" title="25.39.5 The INFORMATION_SCHEMA INNODB_CMP and INNODB_CMP_RESET Tables">Section 25.39.5, “The INFORMATION_SCHEMA INNODB_CMP and INNODB_CMP_RESET Tables”</a></dt><dd></dd><dt><a class="xref" href="innodb-information-schema-examples-compression-sect.html" title="15.14.1.3 Using the Compression Information Schema Tables">Section 15.14.1.3, “Using the Compression Information Schema Tables”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INNODB_CMP_PER_INDEX</h3>
<dl><dt><a class="xref" href="innodb-compression-tuning-monitoring.html" title="15.9.1.4 Monitoring InnoDB Table Compression at Runtime">Section 15.9.1.4, “Monitoring InnoDB Table Compression at Runtime”</a></dt><dd></dd><dt><a class="xref" href="innodb-cmp-per-index-table.html" title="25.39.7 The INFORMATION_SCHEMA INNODB_CMP_PER_INDEX and INNODB_CMP_PER_INDEX_RESET Tables">Section 25.39.7, “The INFORMATION_SCHEMA INNODB_CMP_PER_INDEX and
INNODB_CMP_PER_INDEX_RESET Tables”</a></dt><dd></dd><dt><a class="xref" href="innodb-information-schema-examples-compression-sect.html" title="15.14.1.3 Using the Compression Information Schema Tables">Section 15.14.1.3, “Using the Compression Information Schema Tables”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INNODB_CMP_PER_INDEX_RESET</h3>
<dl><dt><a class="xref" href="innodb-cmp-per-index-table.html" title="25.39.7 The INFORMATION_SCHEMA INNODB_CMP_PER_INDEX and INNODB_CMP_PER_INDEX_RESET Tables">Section 25.39.7, “The INFORMATION_SCHEMA INNODB_CMP_PER_INDEX and
INNODB_CMP_PER_INDEX_RESET Tables”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INNODB_CMP_RESET</h3>
<dl><dt><a class="xref" href="innodb-information-schema-compression-tables.html" title="15.14.1 InnoDB INFORMATION_SCHEMA Tables about Compression">Section 15.14.1, “InnoDB INFORMATION_SCHEMA Tables about Compression”</a></dt><dd></dd><dt><a class="xref" href="innodb-information-schema-innodb_cmp.html" title="15.14.1.1 INNODB_CMP and INNODB_CMP_RESET">Section 15.14.1.1, “INNODB_CMP and INNODB_CMP_RESET”</a></dt><dd></dd><dt><a class="xref" href="innodb-information-schema-innodb_cmpmem.html" title="15.14.1.2 INNODB_CMPMEM and INNODB_CMPMEM_RESET">Section 15.14.1.2, “INNODB_CMPMEM and INNODB_CMPMEM_RESET”</a></dt><dd></dd><dt><a class="xref" href="innodb-cmp-table.html" title="25.39.5 The INFORMATION_SCHEMA INNODB_CMP and INNODB_CMP_RESET Tables">Section 25.39.5, “The INFORMATION_SCHEMA INNODB_CMP and INNODB_CMP_RESET Tables”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INNODB_CMPMEM</h3>
<dl><dt><a class="xref" href="innodb-information-schema-compression-tables.html" title="15.14.1 InnoDB INFORMATION_SCHEMA Tables about Compression">Section 15.14.1, “InnoDB INFORMATION_SCHEMA Tables about Compression”</a></dt><dd></dd><dt><a class="xref" href="innodb-information-schema-innodb_cmpmem.html" title="15.14.1.2 INNODB_CMPMEM and INNODB_CMPMEM_RESET">Section 15.14.1.2, “INNODB_CMPMEM and INNODB_CMPMEM_RESET”</a></dt><dd></dd><dt><a class="xref" href="innodb-cmpmem-table.html" title="25.39.6 The INFORMATION_SCHEMA INNODB_CMPMEM and INNODB_CMPMEM_RESET Tables">Section 25.39.6, “The INFORMATION_SCHEMA INNODB_CMPMEM and INNODB_CMPMEM_RESET Tables”</a></dt><dd></dd><dt><a class="xref" href="innodb-information-schema-examples-compression-sect.html" title="15.14.1.3 Using the Compression Information Schema Tables">Section 15.14.1.3, “Using the Compression Information Schema Tables”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INNODB_CMPMEM_RESET</h3>
<dl><dt><a class="xref" href="innodb-information-schema-innodb_cmpmem.html" title="15.14.1.2 INNODB_CMPMEM and INNODB_CMPMEM_RESET">Section 15.14.1.2, “INNODB_CMPMEM and INNODB_CMPMEM_RESET”</a></dt><dd></dd><dt><a class="xref" href="innodb-cmpmem-table.html" title="25.39.6 The INFORMATION_SCHEMA INNODB_CMPMEM and INNODB_CMPMEM_RESET Tables">Section 25.39.6, “The INFORMATION_SCHEMA INNODB_CMPMEM and INNODB_CMPMEM_RESET Tables”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INNODB_COLUMNS</h3>
<dl><dt><a class="xref" href="data-dictionary-information-schema.html" title="14.5 INFORMATION_SCHEMA and Data Dictionary Integration">Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”</a></dt><dd></dd><dt><a class="xref" href="innodb-information-schema-system-tables.html" title="15.14.3 InnoDB INFORMATION_SCHEMA Schema Object Tables">Section 15.14.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”</a></dt><dd></dd><dt><a class="xref" href="innodb-columns-table.html" title="25.39.8 The INFORMATION_SCHEMA INNODB_COLUMNS Table">Section 25.39.8, “The INFORMATION_SCHEMA INNODB_COLUMNS Table”</a></dt><dd></dd><dt><a class="xref" href="innodb-virtual-table.html" title="25.39.30 The INFORMATION_SCHEMA INNODB_VIRTUAL Table">Section 25.39.30, “The INFORMATION_SCHEMA INNODB_VIRTUAL Table”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INNODB_DATAFILES</h3>
<dl><dt><a class="xref" href="data-dictionary-information-schema.html" title="14.5 INFORMATION_SCHEMA and Data Dictionary Integration">Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”</a></dt><dd></dd><dt><a class="xref" href="innodb-information-schema-system-tables.html" title="15.14.3 InnoDB INFORMATION_SCHEMA Schema Object Tables">Section 15.14.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”</a></dt><dd></dd><dt><a class="xref" href="innodb-information-schema-files-table.html" title="15.14.8 Retrieving InnoDB Tablespace Metadata from INFORMATION_SCHEMA.FILES">Section 15.14.8, “Retrieving InnoDB Tablespace Metadata from INFORMATION_SCHEMA.FILES”</a></dt><dd></dd><dt><a class="xref" href="files-table.html" title="25.11 The INFORMATION_SCHEMA FILES Table">Section 25.11, “The INFORMATION_SCHEMA FILES Table”</a></dt><dd></dd><dt><a class="xref" href="innodb-datafiles-table.html" title="25.39.9 The INFORMATION_SCHEMA INNODB_DATAFILES Table">Section 25.39.9, “The INFORMATION_SCHEMA INNODB_DATAFILES Table”</a></dt><dd></dd><dt><a class="xref" href="innodb-tablespaces-brief-table.html" title="25.39.26 The INFORMATION_SCHEMA INNODB_TABLESPACES_BRIEF Table">Section 25.39.26, “The INFORMATION_SCHEMA INNODB_TABLESPACES_BRIEF Table”</a></dt><dd></dd><dt><a class="xref" href="tablespaces-table.html" title="25.31 The INFORMATION_SCHEMA TABLESPACES Table">Section 25.31, “The INFORMATION_SCHEMA TABLESPACES Table”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INNODB_FIELDS</h3>
<dl><dt><a class="xref" href="data-dictionary-information-schema.html" title="14.5 INFORMATION_SCHEMA and Data Dictionary Integration">Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”</a></dt><dd></dd><dt><a class="xref" href="innodb-information-schema-system-tables.html" title="15.14.3 InnoDB INFORMATION_SCHEMA Schema Object Tables">Section 15.14.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”</a></dt><dd></dd><dt><a class="xref" href="innodb-fields-table.html" title="25.39.10 The INFORMATION_SCHEMA INNODB_FIELDS Table">Section 25.39.10, “The INFORMATION_SCHEMA INNODB_FIELDS Table”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INNODB_FOREIGN</h3>
<dl><dt><a class="xref" href="constraint-foreign-key.html" title="1.8.3.2 FOREIGN KEY Constraints">Section 1.8.3.2, “FOREIGN KEY Constraints”</a></dt><dd></dd><dt><a class="xref" href="data-dictionary-information-schema.html" title="14.5 INFORMATION_SCHEMA and Data Dictionary Integration">Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”</a></dt><dd></dd><dt><a class="xref" href="innodb-information-schema-system-tables.html" title="15.14.3 InnoDB INFORMATION_SCHEMA Schema Object Tables">Section 15.14.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”</a></dt><dd></dd><dt><a class="xref" href="innodb-foreign-table.html" title="25.39.11 The INFORMATION_SCHEMA INNODB_FOREIGN Table">Section 25.39.11, “The INFORMATION_SCHEMA INNODB_FOREIGN Table”</a></dt><dd></dd><dt><a class="xref" href="create-table-foreign-keys.html" title="13.1.20.6 Using FOREIGN KEY Constraints">Section 13.1.20.6, “Using FOREIGN KEY Constraints”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INNODB_FOREIGN_COLS</h3>
<dl><dt><a class="xref" href="constraint-foreign-key.html" title="1.8.3.2 FOREIGN KEY Constraints">Section 1.8.3.2, “FOREIGN KEY Constraints”</a></dt><dd></dd><dt><a class="xref" href="data-dictionary-information-schema.html" title="14.5 INFORMATION_SCHEMA and Data Dictionary Integration">Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”</a></dt><dd></dd><dt><a class="xref" href="innodb-information-schema-system-tables.html" title="15.14.3 InnoDB INFORMATION_SCHEMA Schema Object Tables">Section 15.14.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”</a></dt><dd></dd><dt><a class="xref" href="innodb-foreign-cols-table.html" title="25.39.12 The INFORMATION_SCHEMA INNODB_FOREIGN_COLS Table">Section 25.39.12, “The INFORMATION_SCHEMA INNODB_FOREIGN_COLS Table”</a></dt><dd></dd><dt><a class="xref" href="create-table-foreign-keys.html" title="13.1.20.6 Using FOREIGN KEY Constraints">Section 13.1.20.6, “Using FOREIGN KEY Constraints”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INNODB_FT_BEING_DELETED</h3>
<dl><dt><a class="xref" href="innodb-fulltext-index.html" title="15.6.2.4 InnoDB FULLTEXT Indexes">Section 15.6.2.4, “InnoDB FULLTEXT Indexes”</a></dt><dd></dd><dt><a class="xref" href="innodb-information-schema-fulltext_index-tables.html" title="15.14.4 InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables">Section 15.14.4, “InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables”</a></dt><dd></dd><dt><a class="xref" href="innodb-parameters.html" title="15.13 InnoDB Startup Options and System Variables">Section 15.13, “InnoDB Startup Options and System Variables”</a></dt><dd></dd><dt><a class="xref" href="innodb-ft-being-deleted-table.html" title="25.39.13 The INFORMATION_SCHEMA INNODB_FT_BEING_DELETED Table">Section 25.39.13, “The INFORMATION_SCHEMA INNODB_FT_BEING_DELETED Table”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INNODB_FT_CONFIG</h3>
<dl><dt><a class="xref" href="innodb-fulltext-index.html" title="15.6.2.4 InnoDB FULLTEXT Indexes">Section 15.6.2.4, “InnoDB FULLTEXT Indexes”</a></dt><dd></dd><dt><a class="xref" href="innodb-information-schema-fulltext_index-tables.html" title="15.14.4 InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables">Section 15.14.4, “InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables”</a></dt><dd></dd><dt><a class="xref" href="innodb-parameters.html" title="15.13 InnoDB Startup Options and System Variables">Section 15.13, “InnoDB Startup Options and System Variables”</a></dt><dd></dd><dt><a class="xref" href="innodb-ft-config-table.html" title="25.39.14 The INFORMATION_SCHEMA INNODB_FT_CONFIG Table">Section 25.39.14, “The INFORMATION_SCHEMA INNODB_FT_CONFIG Table”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INNODB_FT_DEFAULT_STOPWORD</h3>
<dl><dt><a class="xref" href="fulltext-stopwords.html" title="12.9.4 Full-Text Stopwords">Section 12.9.4, “Full-Text Stopwords”</a></dt><dd></dd><dt><a class="xref" href="innodb-fulltext-index.html" title="15.6.2.4 InnoDB FULLTEXT Indexes">Section 15.6.2.4, “InnoDB FULLTEXT Indexes”</a></dt><dd></dd><dt><a class="xref" href="innodb-information-schema-fulltext_index-tables.html" title="15.14.4 InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables">Section 15.14.4, “InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables”</a></dt><dd></dd><dt><a class="xref" href="innodb-ft-default-stopword-table.html" title="25.39.15 The INFORMATION_SCHEMA INNODB_FT_DEFAULT_STOPWORD Table">Section 25.39.15, “The INFORMATION_SCHEMA INNODB_FT_DEFAULT_STOPWORD Table”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INNODB_FT_DELETED</h3>
<dl><dt><a class="xref" href="innodb-fulltext-index.html" title="15.6.2.4 InnoDB FULLTEXT Indexes">Section 15.6.2.4, “InnoDB FULLTEXT Indexes”</a></dt><dd></dd><dt><a class="xref" href="innodb-information-schema-fulltext_index-tables.html" title="15.14.4 InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables">Section 15.14.4, “InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables”</a></dt><dd></dd><dt><a class="xref" href="innodb-parameters.html" title="15.13 InnoDB Startup Options and System Variables">Section 15.13, “InnoDB Startup Options and System Variables”</a></dt><dd></dd><dt><a class="xref" href="innodb-ft-being-deleted-table.html" title="25.39.13 The INFORMATION_SCHEMA INNODB_FT_BEING_DELETED Table">Section 25.39.13, “The INFORMATION_SCHEMA INNODB_FT_BEING_DELETED Table”</a></dt><dd></dd><dt><a class="xref" href="innodb-ft-deleted-table.html" title="25.39.16 The INFORMATION_SCHEMA INNODB_FT_DELETED Table">Section 25.39.16, “The INFORMATION_SCHEMA INNODB_FT_DELETED Table”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INNODB_FT_INDEX_CACHE</h3>
<dl><dt><a class="xref" href="innodb-fulltext-index.html" title="15.6.2.4 InnoDB FULLTEXT Indexes">Section 15.6.2.4, “InnoDB FULLTEXT Indexes”</a></dt><dd></dd><dt><a class="xref" href="innodb-information-schema-fulltext_index-tables.html" title="15.14.4 InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables">Section 15.14.4, “InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables”</a></dt><dd></dd><dt><a class="xref" href="innodb-parameters.html" title="15.13 InnoDB Startup Options and System Variables">Section 15.13, “InnoDB Startup Options and System Variables”</a></dt><dd></dd><dt><a class="xref" href="innodb-ft-index-cache-table.html" title="25.39.17 The INFORMATION_SCHEMA INNODB_FT_INDEX_CACHE Table">Section 25.39.17, “The INFORMATION_SCHEMA INNODB_FT_INDEX_CACHE Table”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INNODB_FT_INDEX_TABLE</h3>
<dl><dt><a class="xref" href="innodb-fulltext-index.html" title="15.6.2.4 InnoDB FULLTEXT Indexes">Section 15.6.2.4, “InnoDB FULLTEXT Indexes”</a></dt><dd></dd><dt><a class="xref" href="innodb-information-schema-fulltext_index-tables.html" title="15.14.4 InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables">Section 15.14.4, “InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables”</a></dt><dd></dd><dt><a class="xref" href="innodb-parameters.html" title="15.13 InnoDB Startup Options and System Variables">Section 15.13, “InnoDB Startup Options and System Variables”</a></dt><dd></dd><dt><a class="xref" href="innodb-ft-being-deleted-table.html" title="25.39.13 The INFORMATION_SCHEMA INNODB_FT_BEING_DELETED Table">Section 25.39.13, “The INFORMATION_SCHEMA INNODB_FT_BEING_DELETED Table”</a></dt><dd></dd><dt><a class="xref" href="innodb-ft-deleted-table.html" title="25.39.16 The INFORMATION_SCHEMA INNODB_FT_DELETED Table">Section 25.39.16, “The INFORMATION_SCHEMA INNODB_FT_DELETED Table”</a></dt><dd></dd><dt><a class="xref" href="innodb-ft-index-table-table.html" title="25.39.18 The INFORMATION_SCHEMA INNODB_FT_INDEX_TABLE Table">Section 25.39.18, “The INFORMATION_SCHEMA INNODB_FT_INDEX_TABLE Table”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INNODB_INDEXES</h3>
<dl><dt><a class="xref" href="index-page-merge-threshold.html" title="15.8.11 Configuring the Merge Threshold for Index Pages">Section 15.8.11, “Configuring the Merge Threshold for Index Pages”</a></dt><dd></dd><dt><a class="xref" href="data-dictionary-information-schema.html" title="14.5 INFORMATION_SCHEMA and Data Dictionary Integration">Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”</a></dt><dd></dd><dt><a class="xref" href="innodb-fulltext-index.html" title="15.6.2.4 InnoDB FULLTEXT Indexes">Section 15.6.2.4, “InnoDB FULLTEXT Indexes”</a></dt><dd></dd><dt><a class="xref" href="innodb-information-schema-system-tables.html" title="15.14.3 InnoDB INFORMATION_SCHEMA Schema Object Tables">Section 15.14.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”</a></dt><dd></dd><dt><a class="xref" href="innodb-cached-indexes-table.html" title="25.39.4 The INFORMATION_SCHEMA INNODB_CACHED_INDEXES Table">Section 25.39.4, “The INFORMATION_SCHEMA INNODB_CACHED_INDEXES Table”</a></dt><dd></dd><dt><a class="xref" href="innodb-indexes-table.html" title="25.39.19 The INFORMATION_SCHEMA INNODB_INDEXES Table">Section 25.39.19, “The INFORMATION_SCHEMA INNODB_INDEXES Table”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INNODB_LOCK_WAITS</h3>
<dl><dt><a class="xref" href="innodb-information-schema-transactions.html" title="15.14.2 InnoDB INFORMATION_SCHEMA Transaction and Locking Information">Section 15.14.2, “InnoDB INFORMATION_SCHEMA Transaction and Locking Information”</a></dt><dd></dd><dt><a class="xref" href="innodb-information-schema-understanding-innodb-locking.html" title="15.14.2.2 InnoDB Lock and Lock-Wait Information">Section 15.14.2.2, “InnoDB Lock and Lock-Wait Information”</a></dt><dd></dd><dt><a class="xref" href="innodb-information-schema-internal-data.html" title="15.14.2.3 Persistence and Consistency of InnoDB Transaction and Locking Information">Section 15.14.2.3, “Persistence and Consistency of InnoDB Transaction and Locking
Information”</a></dt><dd></dd><dt><a class="xref" href="innodb-lock-waits-table.html" title="25.39.21 The INFORMATION_SCHEMA INNODB_LOCK_WAITS Table">Section 25.39.21, “The INFORMATION_SCHEMA INNODB_LOCK_WAITS Table”</a></dt><dd></dd><dt><a class="xref" href="innodb-information-schema-examples.html" title="15.14.2.1 Using InnoDB Transaction and Locking Information">Section 15.14.2.1, “Using InnoDB Transaction and Locking Information”</a></dt><dd></dd><dt><a class="xref" href="mysql-nutshell.html" title="1.4 What Is New in MySQL 8.0">Section 1.4, “What Is New in MySQL 8.0”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INNODB_LOCKS</h3>
<dl><dt><a class="xref" href="innodb-information-schema-transactions.html" title="15.14.2 InnoDB INFORMATION_SCHEMA Transaction and Locking Information">Section 15.14.2, “InnoDB INFORMATION_SCHEMA Transaction and Locking Information”</a></dt><dd></dd><dt><a class="xref" href="innodb-information-schema-understanding-innodb-locking.html" title="15.14.2.2 InnoDB Lock and Lock-Wait Information">Section 15.14.2.2, “InnoDB Lock and Lock-Wait Information”</a></dt><dd></dd><dt><a class="xref" href="innodb-information-schema-internal-data.html" title="15.14.2.3 Persistence and Consistency of InnoDB Transaction and Locking Information">Section 15.14.2.3, “Persistence and Consistency of InnoDB Transaction and Locking
Information”</a></dt><dd></dd><dt><a class="xref" href="innodb-locks-table.html" title="25.39.20 The INFORMATION_SCHEMA INNODB_LOCKS Table">Section 25.39.20, “The INFORMATION_SCHEMA INNODB_LOCKS Table”</a></dt><dd></dd><dt><a class="xref" href="innodb-information-schema-examples.html" title="15.14.2.1 Using InnoDB Transaction and Locking Information">Section 15.14.2.1, “Using InnoDB Transaction and Locking Information”</a></dt><dd></dd><dt><a class="xref" href="mysql-nutshell.html" title="1.4 What Is New in MySQL 8.0">Section 1.4, “What Is New in MySQL 8.0”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INNODB_METRICS</h3>
<dl><dt><a class="xref" href="innodb-change-buffer.html" title="15.5.2 Change Buffer">Section 15.5.2, “Change Buffer”</a></dt><dd></dd><dt><a class="xref" href="index-page-merge-threshold.html" title="15.8.11 Configuring the Merge Threshold for Index Pages">Section 15.8.11, “Configuring the Merge Threshold for Index Pages”</a></dt><dd></dd><dt><a class="xref" href="innodb-information-schema-metrics-table.html" title="15.14.6 InnoDB INFORMATION_SCHEMA Metrics Table">Section 15.14.6, “InnoDB INFORMATION_SCHEMA Metrics Table”</a></dt><dd></dd><dt><a class="xref" href="glossary.html" title="MySQL Glossary">MySQL Glossary</a></dt><dd></dd><dt><a class="xref" href="innodb-metrics-table.html" title="25.39.22 The INFORMATION_SCHEMA INNODB_METRICS Table">Section 25.39.22, “The INFORMATION_SCHEMA INNODB_METRICS Table”</a></dt><dd></dd><dt><a class="xref" href="sys-metrics.html" title="27.4.3.21 The metrics View">Section 27.4.3.21, “The metrics View”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INNODB_SESSION_TEMP_TABLESPACES</h3>
<dl><dt><a class="xref" href="innodb-temporary-tablespace.html" title="15.6.3.5 Temporary Tablespaces">Section 15.6.3.5, “Temporary Tablespaces”</a></dt><dd></dd><dt><a class="xref" href="innodb-session-temp-tablespaces-table.html" title="25.39.23 The INFORMATION_SCHEMA INNODB_SESSION_TEMP_TABLESPACES Table">Section 25.39.23, “The INFORMATION_SCHEMA INNODB_SESSION_TEMP_TABLESPACES Table”</a></dt><dd></dd><dt><a class="xref" href="mysql-nutshell.html" title="1.4 What Is New in MySQL 8.0">Section 1.4, “What Is New in MySQL 8.0”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INNODB_SYS_FOREIGN</h3>
<dl><dt><a class="xref" href="create-table-foreign-keys.html" title="13.1.20.6 Using FOREIGN KEY Constraints">Section 13.1.20.6, “Using FOREIGN KEY Constraints”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INNODB_SYS_FOREIGN_COLS</h3>
<dl><dt><a class="xref" href="create-table-foreign-keys.html" title="13.1.20.6 Using FOREIGN KEY Constraints">Section 13.1.20.6, “Using FOREIGN KEY Constraints”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INNODB_TABLES</h3>
<dl><dt><a class="xref" href="data-dictionary-information-schema.html" title="14.5 INFORMATION_SCHEMA and Data Dictionary Integration">Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”</a></dt><dd></dd><dt><a class="xref" href="innodb-fulltext-index.html" title="15.6.2.4 InnoDB FULLTEXT Indexes">Section 15.6.2.4, “InnoDB FULLTEXT Indexes”</a></dt><dd></dd><dt><a class="xref" href="innodb-information-schema-system-tables.html" title="15.14.3 InnoDB INFORMATION_SCHEMA Schema Object Tables">Section 15.14.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”</a></dt><dd></dd><dt><a class="xref" href="innodb-cached-indexes-table.html" title="25.39.4 The INFORMATION_SCHEMA INNODB_CACHED_INDEXES Table">Section 25.39.4, “The INFORMATION_SCHEMA INNODB_CACHED_INDEXES Table”</a></dt><dd></dd><dt><a class="xref" href="innodb-tables-table.html" title="25.39.24 The INFORMATION_SCHEMA INNODB_TABLES Table">Section 25.39.24, “The INFORMATION_SCHEMA INNODB_TABLES Table”</a></dt><dd></dd><dt><a class="xref" href="mysql-nutshell.html" title="1.4 What Is New in MySQL 8.0">Section 1.4, “What Is New in MySQL 8.0”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INNODB_TABLESPACES</h3>
<dl><dt><a class="xref" href="data-dictionary-information-schema.html" title="14.5 INFORMATION_SCHEMA and Data Dictionary Integration">Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”</a></dt><dd></dd><dt><a class="xref" href="innodb-information-schema-system-tables.html" title="15.14.3 InnoDB INFORMATION_SCHEMA Schema Object Tables">Section 15.14.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”</a></dt><dd></dd><dt><a class="xref" href="innodb-information-schema-files-table.html" title="15.14.8 Retrieving InnoDB Tablespace Metadata from INFORMATION_SCHEMA.FILES">Section 15.14.8, “Retrieving InnoDB Tablespace Metadata from INFORMATION_SCHEMA.FILES”</a></dt><dd></dd><dt><a class="xref" href="show-table-status.html" title="13.7.6.36 SHOW TABLE STATUS Syntax">Section 13.7.6.36, “SHOW TABLE STATUS Syntax”</a></dt><dd></dd><dt><a class="xref" href="files-table.html" title="25.11 The INFORMATION_SCHEMA FILES Table">Section 25.11, “The INFORMATION_SCHEMA FILES Table”</a></dt><dd></dd><dt><a class="xref" href="innodb-tablespaces-table.html" title="25.39.25 The INFORMATION_SCHEMA INNODB_TABLESPACES Table">Section 25.39.25, “The INFORMATION_SCHEMA INNODB_TABLESPACES Table”</a></dt><dd></dd><dt><a class="xref" href="innodb-tablespaces-brief-table.html" title="25.39.26 The INFORMATION_SCHEMA INNODB_TABLESPACES_BRIEF Table">Section 25.39.26, “The INFORMATION_SCHEMA INNODB_TABLESPACES_BRIEF Table”</a></dt><dd></dd><dt><a class="xref" href="tables-table.html" title="25.30 The INFORMATION_SCHEMA TABLES Table">Section 25.30, “The INFORMATION_SCHEMA TABLES Table”</a></dt><dd></dd><dt><a class="xref" href="tablespaces-table.html" title="25.31 The INFORMATION_SCHEMA TABLESPACES Table">Section 25.31, “The INFORMATION_SCHEMA TABLESPACES Table”</a></dt><dd></dd><dt><a class="xref" href="mysql-nutshell.html" title="1.4 What Is New in MySQL 8.0">Section 1.4, “What Is New in MySQL 8.0”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INNODB_TABLESPACES_BRIEF</h3>
<dl><dt><a class="xref" href="data-dictionary-information-schema.html" title="14.5 INFORMATION_SCHEMA and Data Dictionary Integration">Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”</a></dt><dd></dd><dt><a class="xref" href="innodb-information-schema-system-tables.html" title="15.14.3 InnoDB INFORMATION_SCHEMA Schema Object Tables">Section 15.14.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”</a></dt><dd></dd><dt><a class="xref" href="innodb-tablespaces-brief-table.html" title="25.39.26 The INFORMATION_SCHEMA INNODB_TABLESPACES_BRIEF Table">Section 25.39.26, “The INFORMATION_SCHEMA INNODB_TABLESPACES_BRIEF Table”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INNODB_TABLESTATS</h3>
<dl><dt><a class="xref" href="data-dictionary-information-schema.html" title="14.5 INFORMATION_SCHEMA and Data Dictionary Integration">Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”</a></dt><dd></dd><dt><a class="xref" href="innodb-information-schema-system-tables.html" title="15.14.3 InnoDB INFORMATION_SCHEMA Schema Object Tables">Section 15.14.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”</a></dt><dd></dd><dt><a class="xref" href="innodb-tablestats-table.html" title="25.39.27 The INFORMATION_SCHEMA INNODB_TABLESTATS View">Section 25.39.27, “The INFORMATION_SCHEMA INNODB_TABLESTATS View”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INNODB_TEMP_TABLE_INFO</h3>
<dl><dt><a class="xref" href="innodb-information-schema-temp-table-info.html" title="15.14.7 InnoDB INFORMATION_SCHEMA Temporary Table Info Table">Section 15.14.7, “InnoDB INFORMATION_SCHEMA Temporary Table Info Table”</a></dt><dd></dd><dt><a class="xref" href="innodb-temp-table-info-table.html" title="25.39.28 The INFORMATION_SCHEMA INNODB_TEMP_TABLE_INFO Table">Section 25.39.28, “The INFORMATION_SCHEMA INNODB_TEMP_TABLE_INFO Table”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INNODB_TRX</h3>
<dl><dt><a class="xref" href="innodb-information-schema-transactions.html" title="15.14.2 InnoDB INFORMATION_SCHEMA Transaction and Locking Information">Section 15.14.2, “InnoDB INFORMATION_SCHEMA Transaction and Locking Information”</a></dt><dd></dd><dt><a class="xref" href="innodb-information-schema-understanding-innodb-locking.html" title="15.14.2.2 InnoDB Lock and Lock-Wait Information">Section 15.14.2.2, “InnoDB Lock and Lock-Wait Information”</a></dt><dd></dd><dt><a class="xref" href="innodb-information-schema-internal-data.html" title="15.14.2.3 Persistence and Consistency of InnoDB Transaction and Locking Information">Section 15.14.2.3, “Persistence and Consistency of InnoDB Transaction and Locking
Information”</a></dt><dd></dd><dt><a class="xref" href="data-locks-table.html" title="26.12.12.1 The data_locks Table">Section 26.12.12.1, “The data_locks Table”</a></dt><dd></dd><dt><a class="xref" href="innodb-trx-table.html" title="25.39.29 The INFORMATION_SCHEMA INNODB_TRX Table">Section 25.39.29, “The INFORMATION_SCHEMA INNODB_TRX Table”</a></dt><dd></dd><dt><a class="xref" href="innodb-information-schema-examples.html" title="15.14.2.1 Using InnoDB Transaction and Locking Information">Section 15.14.2.1, “Using InnoDB Transaction and Locking Information”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INNODB_VIRTUAL</h3>
<dl><dt><a class="xref" href="innodb-virtual-table.html" title="25.39.30 The INFORMATION_SCHEMA INNODB_VIRTUAL Table">Section 25.39.30, “The INFORMATION_SCHEMA INNODB_VIRTUAL Table”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<a name="is-index-K"></a><h3 class="title">K</h3>
<p>[<a class="link" href="dynindex-is.html#is-index-top">index top</a>]</p><dl><dt></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">KEY_COLUMN_USAGE</h3>
<dl><dt><a class="xref" href="data-dictionary-information-schema.html" title="14.5 INFORMATION_SCHEMA and Data Dictionary Integration">Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”</a></dt><dd></dd><dt><a class="xref" href="key-column-usage-table.html" title="25.12 The INFORMATION_SCHEMA KEY_COLUMN_USAGE Table">Section 25.12, “The INFORMATION_SCHEMA KEY_COLUMN_USAGE Table”</a></dt><dd></dd><dt><a class="xref" href="system-schema.html" title="5.3 The mysql System Schema">Section 5.3, “The mysql System Schema”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">KEYWORDS</h3>
<dl><dt><a class="xref" href="keywords-table.html" title="25.14 The INFORMATION_SCHEMA KEYWORDS Table">Section 25.14, “The INFORMATION_SCHEMA KEYWORDS Table”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<a name="is-index-N"></a><h3 class="title">N</h3>
<p>[<a class="link" href="dynindex-is.html#is-index-top">index top</a>]</p><dl><dt></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">NDB_TRANSID_MYSQL_CONNECTION_MAP</h3>
<dl><dt><a class="xref" href="mysql-cluster-ndbinfo-server-operations.html" title="22.5.10.34 The ndbinfo server_operations Table">Section 22.5.10.34, “The ndbinfo server_operations Table”</a></dt><dd></dd><dt><a class="xref" href="mysql-cluster-ndbinfo-server-transactions.html" title="22.5.10.35 The ndbinfo server_transactions Table">Section 22.5.10.35, “The ndbinfo server_transactions Table”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ndb_transid_mysql_connection_map</h3>
<dl><dt><a class="xref" href="mysql-cluster-i_s-tables.html" title="22.5.11 INFORMATION_SCHEMA Tables for NDB Cluster">Section 22.5.11, “INFORMATION_SCHEMA Tables for NDB Cluster”</a></dt><dd></dd><dt><a class="xref" href="mysql-cluster-options-variables.html#mysql-cluster-program-options-mysqld" title="22.3.3.9.1 MySQL Server Options for NDB Cluster">Section 22.3.3.9.1, “MySQL Server Options for NDB Cluster”</a></dt><dd></dd><dt><a class="xref" href="mysql-cluster-ndbinfo.html" title="22.5.10 ndbinfo: The NDB Cluster Information Database">Section 22.5.10, “ndbinfo: The NDB Cluster Information Database”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<a name="is-index-O"></a><h3 class="title">O</h3>
<p>[<a class="link" href="dynindex-is.html#is-index-top">index top</a>]</p><dl><dt></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">OPTIMIZER_TRACE</h3>
<dl><dt><a class="xref" href="optimizer-trace-table.html" title="25.15 The INFORMATION_SCHEMA OPTIMIZER_TRACE Table">Section 25.15, “The INFORMATION_SCHEMA OPTIMIZER_TRACE Table”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<a name="is-index-P"></a><h3 class="title">P</h3>
<p>[<a class="link" href="dynindex-is.html#is-index-top">index top</a>]</p><dl><dt></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">PARAMETERS</h3>
<dl><dt><a class="xref" href="data-dictionary-information-schema.html" title="14.5 INFORMATION_SCHEMA and Data Dictionary Integration">Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”</a></dt><dd></dd><dt><a class="xref" href="faqs-stored-procs.html" title="A.4 MySQL 8.0 FAQ: Stored Procedures and Functions">Section A.4, “MySQL 8.0 FAQ: Stored Procedures and Functions”</a></dt><dd></dd><dt><a class="xref" href="show-procedure-status.html" title="13.7.6.28 SHOW PROCEDURE STATUS Syntax">Section 13.7.6.28, “SHOW PROCEDURE STATUS Syntax”</a></dt><dd></dd><dt><a class="xref" href="parameters-table.html" title="25.16 The INFORMATION_SCHEMA PARAMETERS Table">Section 25.16, “The INFORMATION_SCHEMA PARAMETERS Table”</a></dt><dd></dd><dt><a class="xref" href="routines-table.html" title="25.23 The INFORMATION_SCHEMA ROUTINES Table">Section 25.23, “The INFORMATION_SCHEMA ROUTINES Table”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">PARTITIONS</h3>
<dl><dt><a class="xref" href="partitioning-management-exchange.html" title="23.3.3 Exchanging Partitions and Subpartitions with Tables">Section 23.3.3, “Exchanging Partitions and Subpartitions with Tables”</a></dt><dd></dd><dt><a class="xref" href="partitioning-handling-nulls.html" title="23.2.7 How MySQL Partitioning Handles NULL">Section 23.2.7, “How MySQL Partitioning Handles NULL”</a></dt><dd></dd><dt><a class="xref" href="data-dictionary-information-schema.html" title="14.5 INFORMATION_SCHEMA and Data Dictionary Integration">Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”</a></dt><dd></dd><dt><a class="xref" href="partitioning-info.html" title="23.3.5 Obtaining Information About Partitions">Section 23.3.5, “Obtaining Information About Partitions”</a></dt><dd></dd><dt><a class="xref" href="partitioning.html" title="Chapter 23 Partitioning">Chapter 23, <i>Partitioning</i></a></dt><dd></dd><dt><a class="xref" href="show-table-status.html" title="13.7.6.36 SHOW TABLE STATUS Syntax">Section 13.7.6.36, “SHOW TABLE STATUS Syntax”</a></dt><dd></dd><dt><a class="xref" href="partitions-table.html" title="25.17 The INFORMATION_SCHEMA PARTITIONS Table">Section 25.17, “The INFORMATION_SCHEMA PARTITIONS Table”</a></dt><dd></dd><dt><a class="xref" href="tables-table.html" title="25.30 The INFORMATION_SCHEMA TABLES Table">Section 25.30, “The INFORMATION_SCHEMA TABLES Table”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">PLUGINS</h3>
<dl><dt><a class="xref" href="install-plugin.html" title="13.7.4.4 INSTALL PLUGIN Syntax">Section 13.7.4.4, “INSTALL PLUGIN Syntax”</a></dt><dd></dd><dt><a class="xref" href="obtaining-plugin-information.html" title="5.6.2 Obtaining Server Plugin Information">Section 5.6.2, “Obtaining Server Plugin Information”</a></dt><dd></dd><dt><a class="xref" href="plugins-table.html" title="25.18 The INFORMATION_SCHEMA PLUGINS Table">Section 25.18, “The INFORMATION_SCHEMA PLUGINS Table”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">PROCESSLIST</h3>
<dl><dt><a class="xref" href="thread-information.html" title="8.14 Examining Thread Information">Section 8.14, “Examining Thread Information”</a></dt><dd></dd><dt><a class="xref" href="kill.html" title="13.7.7.4 KILL Syntax">Section 13.7.7.4, “KILL Syntax”</a></dt><dd></dd><dt><a class="xref" href="explain-for-connection.html" title="8.8.4 Obtaining Execution Plan Information for a Named Connection">Section 8.8.4, “Obtaining Execution Plan Information for a Named Connection”</a></dt><dd></dd><dt><a class="xref" href="innodb-information-schema-internal-data.html" title="15.14.2.3 Persistence and Consistency of InnoDB Transaction and Locking Information">Section 15.14.2.3, “Persistence and Consistency of InnoDB Transaction and Locking
Information”</a></dt><dd></dd><dt><a class="xref" href="show-processlist.html" title="13.7.6.29 SHOW PROCESSLIST Syntax">Section 13.7.6.29, “SHOW PROCESSLIST Syntax”</a></dt><dd></dd><dt><a class="xref" href="innodb-trx-table.html" title="25.39.29 The INFORMATION_SCHEMA INNODB_TRX Table">Section 25.39.29, “The INFORMATION_SCHEMA INNODB_TRX Table”</a></dt><dd></dd><dt><a class="xref" href="processlist-table.html" title="25.19 The INFORMATION_SCHEMA PROCESSLIST Table">Section 25.19, “The INFORMATION_SCHEMA PROCESSLIST Table”</a></dt><dd></dd><dt><a class="xref" href="sys-processlist.html" title="27.4.3.22 The processlist and x$processlist Views">Section 27.4.3.22, “The processlist and x$processlist Views”</a></dt><dd></dd><dt><a class="xref" href="threads-table.html" title="26.12.17.5 The threads Table">Section 26.12.17.5, “The threads Table”</a></dt><dd></dd><dt><a class="xref" href="innodb-information-schema-examples.html" title="15.14.2.1 Using InnoDB Transaction and Locking Information">Section 15.14.2.1, “Using InnoDB Transaction and Locking Information”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">PROFILING</h3>
<dl><dt><a class="xref" href="show-profile.html" title="13.7.6.30 SHOW PROFILE Syntax">Section 13.7.6.30, “SHOW PROFILE Syntax”</a></dt><dd></dd><dt><a class="xref" href="profiling-table.html" title="25.20 The INFORMATION_SCHEMA PROFILING Table">Section 25.20, “The INFORMATION_SCHEMA PROFILING Table”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<a name="is-index-R"></a><h3 class="title">R</h3>
<p>[<a class="link" href="dynindex-is.html#is-index-top">index top</a>]</p><dl><dt></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">REFERENTIAL_CONSTRAINTS</h3>
<dl><dt><a class="xref" href="data-dictionary-information-schema.html" title="14.5 INFORMATION_SCHEMA and Data Dictionary Integration">Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”</a></dt><dd></dd><dt><a class="xref" href="referential-constraints-table.html" title="25.21 The INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS Table">Section 25.21, “The INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS Table”</a></dt><dd></dd><dt><a class="xref" href="system-schema.html" title="5.3 The mysql System Schema">Section 5.3, “The mysql System Schema”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">RESOURCE_GROUPS</h3>
<dl><dt><a class="xref" href="data-dictionary-information-schema.html" title="14.5 INFORMATION_SCHEMA and Data Dictionary Integration">Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”</a></dt><dd></dd><dt><a class="xref" href="resource-groups.html" title="8.12.5 Resource Groups">Section 8.12.5, “Resource Groups”</a></dt><dd></dd><dt><a class="xref" href="resource-groups-table.html" title="25.22 The INFORMATION_SCHEMA RESOURCE_GROUPS Table">Section 25.22, “The INFORMATION_SCHEMA RESOURCE_GROUPS Table”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">ROUTINES</h3>
<dl><dt><a class="xref" href="data-dictionary-information-schema.html" title="14.5 INFORMATION_SCHEMA and Data Dictionary Integration">Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”</a></dt><dd></dd><dt><a class="xref" href="information-schema-introduction.html" title="25.1 Introduction">Section 25.1, “Introduction”</a></dt><dd></dd><dt><a class="xref" href="faqs-stored-procs.html" title="A.4 MySQL 8.0 FAQ: Stored Procedures and Functions">Section A.4, “MySQL 8.0 FAQ: Stored Procedures and Functions”</a></dt><dd></dd><dt><a class="xref" href="show-procedure-status.html" title="13.7.6.28 SHOW PROCEDURE STATUS Syntax">Section 13.7.6.28, “SHOW PROCEDURE STATUS Syntax”</a></dt><dd></dd><dt><a class="xref" href="stored-routines-metadata.html" title="24.2.3 Stored Routine Metadata">Section 24.2.3, “Stored Routine Metadata”</a></dt><dd></dd><dt><a class="xref" href="routines-table.html" title="25.23 The INFORMATION_SCHEMA ROUTINES Table">Section 25.23, “The INFORMATION_SCHEMA ROUTINES Table”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<a name="is-index-S"></a><h3 class="title">S</h3>
<p>[<a class="link" href="dynindex-is.html#is-index-top">index top</a>]</p><dl><dt></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">SCHEMA_PRIVILEGES</h3>
<dl><dt><a class="xref" href="schema-privileges-table.html" title="25.25 The INFORMATION_SCHEMA SCHEMA_PRIVILEGES Table">Section 25.25, “The INFORMATION_SCHEMA SCHEMA_PRIVILEGES Table”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">SCHEMATA</h3>
<dl><dt><a class="xref" href="grant-tables.html" title="6.2.3 Grant Tables">Section 6.2.3, “Grant Tables”</a></dt><dd></dd><dt><a class="xref" href="data-dictionary-information-schema.html" title="14.5 INFORMATION_SCHEMA and Data Dictionary Integration">Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”</a></dt><dd></dd><dt><a class="xref" href="privileges-provided.html" title="6.2.2 Privileges Provided by MySQL">Section 6.2.2, “Privileges Provided by MySQL”</a></dt><dd></dd><dt><a class="xref" href="server-system-variables.html" title="5.1.8 Server System Variables">Section 5.1.8, “Server System Variables”</a></dt><dd></dd><dt><a class="xref" href="show-databases.html" title="13.7.6.14 SHOW DATABASES Syntax">Section 13.7.6.14, “SHOW DATABASES Syntax”</a></dt><dd></dd><dt><a class="xref" href="schemata-table.html" title="25.24 The INFORMATION_SCHEMA SCHEMATA Table">Section 25.24, “The INFORMATION_SCHEMA SCHEMATA Table”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">SESSION_STATUS</h3>
<dl><dt><a class="xref" href="mysql-cluster-management.html" title="22.5 Management of NDB Cluster">Section 22.5, “Management of NDB Cluster”</a></dt><dd></dd><dt><a class="xref" href="mysql-cluster-ndb-api-statistics.html" title="22.5.17 NDB API Statistics Counters and Variables">Section 22.5.17, “NDB API Statistics Counters and Variables”</a></dt><dd></dd><dt><a class="xref" href="mysql-cluster-replication.html" title="22.6 NDB Cluster Replication">Section 22.6, “NDB Cluster Replication”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">ST_GEOMETRY_COLUMNS</h3>
<dl><dt><a class="xref" href="data-dictionary-information-schema.html" title="14.5 INFORMATION_SCHEMA and Data Dictionary Integration">Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”</a></dt><dd></dd><dt><a class="xref" href="columns-table.html" title="25.6 The INFORMATION_SCHEMA COLUMNS Table">Section 25.6, “The INFORMATION_SCHEMA COLUMNS Table”</a></dt><dd></dd><dt><a class="xref" href="st-geometry-columns-table.html" title="25.27 The INFORMATION_SCHEMA ST_GEOMETRY_COLUMNS Table">Section 25.27, “The INFORMATION_SCHEMA ST_GEOMETRY_COLUMNS Table”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">ST_SPATIAL_REFERENCE_SYSTEMS</h3>
<dl><dt><a class="xref" href="create-spatial-reference-system.html" title="13.1.19 CREATE SPATIAL REFERENCE SYSTEM Syntax">Section 13.1.19, “CREATE SPATIAL REFERENCE SYSTEM Syntax”</a></dt><dd></dd><dt><a class="xref" href="data-dictionary-information-schema.html" title="14.5 INFORMATION_SCHEMA and Data Dictionary Integration">Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”</a></dt><dd></dd><dt><a class="xref" href="spatial-reference-systems.html" title="11.5.5 Spatial Reference System Support">Section 11.5.5, “Spatial Reference System Support”</a></dt><dd></dd><dt><a class="xref" href="st-spatial-reference-systems-table.html" title="25.28 The INFORMATION_SCHEMA ST_SPATIAL_REFERENCE_SYSTEMS Table">Section 25.28, “The INFORMATION_SCHEMA ST_SPATIAL_REFERENCE_SYSTEMS Table”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">ST_UNITS_OF_MEASURE</h3>
<dl><dt><a class="xref" href="gis-linestring-property-functions.html" title="12.16.7.3 LineString and MultiLineString Property Functions">Section 12.16.7.3, “LineString and MultiLineString Property Functions”</a></dt><dd></dd><dt><a class="xref" href="spatial-relation-functions-object-shapes.html" title="12.16.9.1 Spatial Relation Functions That Use Object Shapes">Section 12.16.9.1, “Spatial Relation Functions That Use Object Shapes”</a></dt><dd></dd><dt><a class="xref" href="st-units-of-measure-table.html" title="25.29 The INFORMATION_SCHEMA ST_UNITS_OF_MEASURE Table">Section 25.29, “The INFORMATION_SCHEMA ST_UNITS_OF_MEASURE Table”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">STATISTICS</h3>
<dl><dt><a class="xref" href="analyze-table.html" title="13.7.3.1 ANALYZE TABLE Syntax">Section 13.7.3.1, “ANALYZE TABLE Syntax”</a></dt><dd></dd><dt><a class="xref" href="data-dictionary-usage-differences.html" title="14.7 Data Dictionary Usage Differences">Section 14.7, “Data Dictionary Usage Differences”</a></dt><dd></dd><dt><a class="xref" href="data-dictionary-information-schema.html" title="14.5 INFORMATION_SCHEMA and Data Dictionary Integration">Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”</a></dt><dd></dd><dt><a class="xref" href="show-index.html" title="13.7.6.22 SHOW INDEX Syntax">Section 13.7.6.22, “SHOW INDEX Syntax”</a></dt><dd></dd><dt><a class="xref" href="statistics-table.html" title="25.26 The INFORMATION_SCHEMA STATISTICS Table">Section 25.26, “The INFORMATION_SCHEMA STATISTICS Table”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<a name="is-index-T"></a><h3 class="title">T</h3>
<p>[<a class="link" href="dynindex-is.html#is-index-top">index top</a>]</p><dl><dt></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">TABLE_CONSTRAINTS</h3>
<dl><dt><a class="xref" href="data-dictionary-information-schema.html" title="14.5 INFORMATION_SCHEMA and Data Dictionary Integration">Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”</a></dt><dd></dd><dt><a class="xref" href="referential-constraints-table.html" title="25.21 The INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS Table">Section 25.21, “The INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS Table”</a></dt><dd></dd><dt><a class="xref" href="table-constraints-table.html" title="25.32 The INFORMATION_SCHEMA TABLE_CONSTRAINTS Table">Section 25.32, “The INFORMATION_SCHEMA TABLE_CONSTRAINTS Table”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">TABLE_PRIVILEGES</h3>
<dl><dt><a class="xref" href="table-privileges-table.html" title="25.33 The INFORMATION_SCHEMA TABLE_PRIVILEGES Table">Section 25.33, “The INFORMATION_SCHEMA TABLE_PRIVILEGES Table”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">TABLES</h3>
<dl><dt><a class="xref" href="create-table.html" title="13.1.20 CREATE TABLE Syntax">Section 13.1.20, “CREATE TABLE Syntax”</a></dt><dd></dd><dt><a class="xref" href="data-dictionary-usage-differences.html" title="14.7 Data Dictionary Usage Differences">Section 14.7, “Data Dictionary Usage Differences”</a></dt><dd></dd><dt><a class="xref" href="data-dictionary-information-schema.html" title="14.5 INFORMATION_SCHEMA and Data Dictionary Integration">Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”</a></dt><dd></dd><dt><a class="xref" href="information-schema-introduction.html" title="25.1 Introduction">Section 25.1, “Introduction”</a></dt><dd></dd><dt><a class="xref" href="create-table-ndb-table-comment-options.html" title="13.1.20.11 Setting NDB_TABLE Options">Section 13.1.20.11, “Setting NDB_TABLE Options”</a></dt><dd></dd><dt><a class="xref" href="show-table-status.html" title="13.7.6.36 SHOW TABLE STATUS Syntax">Section 13.7.6.36, “SHOW TABLE STATUS Syntax”</a></dt><dd></dd><dt><a class="xref" href="show-tables.html" title="13.7.6.37 SHOW TABLES Syntax">Section 13.7.6.37, “SHOW TABLES Syntax”</a></dt><dd></dd><dt><a class="xref" href="tables-table.html" title="25.30 The INFORMATION_SCHEMA TABLES Table">Section 25.30, “The INFORMATION_SCHEMA TABLES Table”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">TABLESPACES</h3>
<dl><dt><a class="xref" href="tablespaces-table.html" title="25.31 The INFORMATION_SCHEMA TABLESPACES Table">Section 25.31, “The INFORMATION_SCHEMA TABLESPACES Table”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">TP_THREAD_STATE</h3>
<dl><dt><a class="xref" href="thread-pool-installation.html" title="5.6.3.2 Thread Pool Installation">Section 5.6.3.2, “Thread Pool Installation”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">TRIGGERS</h3>
<dl><dt><a class="xref" href="data-dictionary-information-schema.html" title="14.5 INFORMATION_SCHEMA and Data Dictionary Integration">Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”</a></dt><dd></dd><dt><a class="xref" href="upgrade-prerequisites.html" title="2.11.5 Preparing Your Installation for Upgrade">Section 2.11.5, “Preparing Your Installation for Upgrade”</a></dt><dd></dd><dt><a class="xref" href="show-create-trigger.html" title="13.7.6.11 SHOW CREATE TRIGGER Syntax">Section 13.7.6.11, “SHOW CREATE TRIGGER Syntax”</a></dt><dd></dd><dt><a class="xref" href="show-triggers.html" title="13.7.6.38 SHOW TRIGGERS Syntax">Section 13.7.6.38, “SHOW TRIGGERS Syntax”</a></dt><dd></dd><dt><a class="xref" href="triggers-table.html" title="25.34 The INFORMATION_SCHEMA TRIGGERS Table">Section 25.34, “The INFORMATION_SCHEMA TRIGGERS Table”</a></dt><dd></dd><dt><a class="xref" href="trigger-metadata.html" title="24.3.2 Trigger Metadata">Section 24.3.2, “Trigger Metadata”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<a name="is-index-U"></a><h3 class="title">U</h3>
<p>[<a class="link" href="dynindex-is.html#is-index-top">index top</a>]</p><dl><dt></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">USER_PRIVILEGES</h3>
<dl><dt><a class="xref" href="privileges-provided.html" title="6.2.2 Privileges Provided by MySQL">Section 6.2.2, “Privileges Provided by MySQL”</a></dt><dd></dd><dt><a class="xref" href="user-privileges-table.html" title="25.35 The INFORMATION_SCHEMA USER_PRIVILEGES Table">Section 25.35, “The INFORMATION_SCHEMA USER_PRIVILEGES Table”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<a name="is-index-V"></a><h3 class="title">V</h3>
<p>[<a class="link" href="dynindex-is.html#is-index-top">index top</a>]</p><dl><dt></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">VIEW_ROUTINE_USAGE</h3>
<dl><dt><a class="xref" href="data-dictionary-information-schema.html" title="14.5 INFORMATION_SCHEMA and Data Dictionary Integration">Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”</a></dt><dd></dd><dt><a class="xref" href="view-routine-usage-table.html" title="25.37 The INFORMATION_SCHEMA VIEW_ROUTINE_USAGE Table">Section 25.37, “The INFORMATION_SCHEMA VIEW_ROUTINE_USAGE Table”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">VIEW_TABLE_USAGE</h3>
<dl><dt><a class="xref" href="data-dictionary-information-schema.html" title="14.5 INFORMATION_SCHEMA and Data Dictionary Integration">Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”</a></dt><dd></dd><dt><a class="xref" href="view-table-usage-table.html" title="25.38 The INFORMATION_SCHEMA VIEW_TABLE_USAGE Table">Section 25.38, “The INFORMATION_SCHEMA VIEW_TABLE_USAGE Table”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">VIEWS</h3>
<dl><dt><a class="xref" href="data-dictionary-information-schema.html" title="14.5 INFORMATION_SCHEMA and Data Dictionary Integration">Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”</a></dt><dd></dd><dt><a class="xref" href="show-create-view.html" title="13.7.6.13 SHOW CREATE VIEW Syntax">Section 13.7.6.13, “SHOW CREATE VIEW Syntax”</a></dt><dd></dd><dt><a class="xref" href="views-table.html" title="25.36 The INFORMATION_SCHEMA VIEWS Table">Section 25.36, “The INFORMATION_SCHEMA VIEWS Table”</a></dt><dd></dd><dt><a class="xref" href="view-metadata.html" title="24.5.5 View Metadata">Section 24.5.5, “View Metadata”</a></dt><dd></dd></dl>
</div>

</div>

<br />
        </div>

                <div id="docs-in-page-nav-container">
            <div id="docs-in-page-nav">
                
    <a href="dynindex-function.html"
        aria-label="Previous" title="Previous: Function Index"><span
        class="icon-chevron-left"></span> PREV</a> &nbsp;
<a href="index.html" aria-label="Start" title="Start"> HOME</a> &nbsp;
        <a aria-label="Up" href="indexes.html" title="Up: Indexes"> UP</a> &nbsp;
    <a href="dynindex-jointype.html" aria-label="Next"
        title="Next: Join Types Index">NEXT <span
        class="icon-chevron-right"></span></a>
            </div>
        </div>
        
         <div id="docs-body-extra">
             
<a class="docs-sidebar-section" href=""><span class="icon-related"></span>
    <span class="text">Related Documentation</span></a>
<div class="docs-sidebar-accordian">
    <div class="text">
        <a href="/doc/relnotes/mysql/8.0/en/">MySQL 8.0 Release Notes</a><br />
        <a href="/doc/dev/mysql-server/latest/">MySQL 8.0 Source Code Documentation</a><br />
        </div>
</div>

    <a class="docs-sidebar-section" href=""><span class="icon-download-thin"></span>
        <span class="text">
            Download
                            this Manual
                    </span>
    </a>
    <div class="docs-sidebar-accordian">
        <div class="text">
                        <a href="https://downloads.mysql.com/docs/refman-8.0-en.pdf">PDF (US Ltr)</a>
            - 46.1Mb<br />
                        <a href="https://downloads.mysql.com/docs/refman-8.0-en.a4.pdf">PDF (A4)</a>
            - 46.1Mb<br />
                        <a href="https://downloads.mysql.com/docs/mysql-ref-manual-8.0-en-pdf-1-20190611.noarch.rpm">PDF (RPM)</a>
            - 41.5Mb<br />
                        <a href="https://downloads.mysql.com/docs/refman-8.0-en.html-chapter.tar.gz">HTML Download (TGZ)</a>
            - 10.6Mb<br />
                        <a href="https://downloads.mysql.com/docs/refman-8.0-en.html-chapter.zip">HTML Download (Zip)</a>
            - 10.6Mb<br />
                        <a href="https://downloads.mysql.com/docs/mysql-ref-manual-8.0-en-html-chapter-1-20190611.noarch.rpm">HTML Download (RPM)</a>
            - 9.1Mb<br />
                        <a href="https://downloads.mysql.com/docs/refman-8.0-en.man-gpl.tar.gz">Man Pages (TGZ)</a>
            - 220.4Kb<br />
                        <a href="https://downloads.mysql.com/docs/refman-8.0-en.man-gpl.zip">Man Pages (Zip)</a>
            - 325.8Kb<br />
                        <a href="https://downloads.mysql.com/docs/mysql-8.0.info.gz">Info (Gzip)</a>
            - 4.1Mb<br />
                        <a href="https://downloads.mysql.com/docs/mysql-8.0.info.zip">Info (Zip)</a>
            - 4.1Mb<br />
                    </div>
    </div>

<a class="docs-sidebar-section" href=""><span class="icon-book"></span>
    <span class="text">Excerpts from this Manual</span></a>
<div class="docs-sidebar-accordian">
    <div class="text">
                <a href="/doc/mysql-backup-excerpt/8.0/en/">MySQL Backup and Recovery</a><br />
                <a href="/doc/mysql-g11n-excerpt/8.0/en/">MySQL Globalization</a><br />
                <a href="/doc/mysql-infoschema-excerpt/8.0/en/">MySQL Information Schema</a><br />
                <a href="/doc/mysql-installation-excerpt/8.0/en/">MySQL Installation Guide</a><br />
                <a href="/doc/mysql-security-excerpt/8.0/en/">Security in MySQL</a><br />
                <a href="/doc/mysql-startstop-excerpt/8.0/en/">Starting and Stopping MySQL</a><br />
                <a href="/doc/mysql-linuxunix-excerpt/8.0/en/">MySQL and Linux/Unix</a><br />
                <a href="/doc/mysql-windows-excerpt/8.0/en/">MySQL and Windows</a><br />
                <a href="/doc/mysql-osx-excerpt/8.0/en/">MySQL and OS X</a><br />
                <a href="/doc/mysql-solaris-excerpt/8.0/en/">MySQL and Solaris</a><br />
                <a href="/doc/mysql-sourcebuild-excerpt/8.0/en/">Building MySQL from Source</a><br />
                <a href="/doc/mysql-reslimits-excerpt/8.0/en/">MySQL Restrictions and Limitations</a><br />
                <a href="/doc/mysql-partitioning-excerpt/8.0/en/">MySQL Partitioning</a><br />
                <a href="/doc/mysql-secure-deployment-guide/8.0/en/">MySQL Secure Deployment Guide</a><br />
                <a href="/doc/mysql-tutorial-excerpt/8.0/en/">MySQL Tutorial</a><br />
                <a href="/doc/mysql-perfschema-excerpt/8.0/en/">MySQL Performance Schema</a><br />
                <a href="/doc/mysql-replication-excerpt/8.0/en/">MySQL Replication</a><br />
                <a href="/doc/mysql-repo-excerpt/8.0/en/">Using the MySQL Yum Repository</a><br />
            </div>
</div>
         </div>

              </div>
     </div>

</div>

<script>
$(function() {
    var doc = new $.doc({ 'mobile': $.browser.mobile, 'docId': 1, 'highlight': true });
});
</script>
    

            
        </div>
    </div>

    <footer class="collapsed">
        <div id="footer-bottom">
                                    <div id="footer-collapse">
                <a href="" id="expand-footer"
                    aria-label="Expand Footer"
                    title="Expand Footer"><span
                    class="icon-plus-square"></span></a>
            </div>
                        <div class="footer-contact">
                <div id="footer-contact-icon" style="display: none;">
                    <span class="icon-call-phone"></span>
                </div>
                <div id="footer-contact-numbers" style="display: none;">
                    <strong>Contact MySQL Sales</strong><br/>
                    USA/Canada: +1-866-221-0634 &nbsp;
                    (<a href="https://www.mysql.com/about/contact/phone/">More Countries &raquo;</a>)
                </div>
                <div id="footer-contact-copyright" style="display: inline-block;">
                    <a href="http://www.oracle.com/" aria-label="Oracle" title="Oracle"><span class="oracle-logo"></span></a>
                    &nbsp; &copy; 2019, Oracle Corporation and/or its affiliates
                </div>
            </div>
            <div class="social-icons">
                <a aria-label="Join us on Facebook" title="Join us on Facebook" href="http://www.facebook.com/mysql"><span class="icon-facebook-square"></span></a>
                <a aria-label="Follow us on Twitter" title="Follow us on Twitter" href="https://twitter.com/mysql"><span class="icon-twitter-square"></span></a>
                <a aria-label="Follow us on LinkedIn" title="Follow us on LinkedIn" href="https://www.linkedin.com/company/mysql"><span class="icon-linkedin-square"></span></a>
                <a aria-label="Visit our YouTube channel" title="Visit our YouTube channel" href="http://www.youtube.com/mysqlchannel"><span class="icon-youtube-square"></span></a>
            </div>
            <br class="clear" />
        </div>
        <div id="footer-links">

            <div id="footer-nav"></div>

            <div class="links">
                <ul>
                    <li class="top"><a href="https://www.mysql.com/products/">Products</a></li>
                    <li><a href="https://www.mysql.com/cloud/">Oracle MySQL Cloud Service</a></li>
                    <li><a href="https://www.mysql.com/products/enterprise/">MySQL Enterprise Edition</a></li>
                    <li><a href="https://www.mysql.com/products/standard/">MySQL Standard Edition</a></li>
                    <li><a href="https://www.mysql.com/products/classic/">MySQL Classic Edition</a></li>
                    <li><a href="https://www.mysql.com/products/cluster/">MySQL Cluster CGE</a></li>
                    <li><a href="https://www.mysql.com/oem/">MySQL Embedded (OEM/ISV)</a></li>
                </ul>
            </div>

            <div class="links">
                <ul>
                    <li class="top"><a href="https://www.mysql.com/services/">Services</a></li>
                    <li><a href="https://www.mysql.com/training/">Training</a></li>
                    <li><a href="https://www.mysql.com/certification/">Certification</a></li>
                    <li><a href="https://www.mysql.com/consulting/">Consulting</a></li>
                    <li><a href="https://www.mysql.com/support/">Support</a></li>
                </ul>
            </div>

            <div class="links">
                <ul>
                    <li class="top"><a href="https://dev.mysql.com/downloads/">Downloads</a></li>
                    <li><a href="https://dev.mysql.com/downloads/mysql/">MySQL Community Server</a></li>
                    <li><a href="https://dev.mysql.com/downloads/cluster/">MySQL NDB Cluster</a></li>
                    <li><a href="https://dev.mysql.com/downloads/shell/">MySQL Shell</a></li>
                    <li><a href="https://dev.mysql.com/downloads/router/">MySQL Router</a></li>
                    <li><a href="https://dev.mysql.com/downloads/workbench/">MySQL Workbench</a></li>
                </ul>
            </div>

            <div class="links">
                <ul>
                    <li class="top"><a href="https://dev.mysql.com/doc/">Documentation</a></li>
                    <li><a href="https://dev.mysql.com/doc/refman/en/">MySQL Reference Manual</a></li>
                    <li><a href="https://dev.mysql.com/doc/workbench/en/">MySQL Workbench</a></li>
                    <li><a href="https://dev.mysql.com/doc/index-cluster.html">MySQL NDB Cluster</a></li>
                    <li><a href="https://dev.mysql.com/doc/index-connectors.html">MySQL Connectors</a></li>
                    <li><a href="https://dev.mysql.com/doc/#topic">Topic Guides</a></li>
                </ul>
            </div>

            <div class="links">
                <ul>
                    <li class="top"><a href="https://www.mysql.com/about/">About MySQL</a></li>
                    <li><a href="https://www.mysql.com/about/contact/">Contact Us</a></li>
                                                            <li><a href="https://www.mysql.com/buy-mysql/">How to Buy</a></li>
                    <li><a href="https://www.mysql.com/partners/">Partners</a></li>
                    <li><a href="https://www.mysql.com/about/jobs/">Job Opportunities</a></li>
                    <li><a href="https://www.mysql.com/sitemap.html">Site Map</a></li>
                </ul>
            </div>

            
            <div id="footer-logo">
                <a href="http://www.oracle.com/" aria-label="Oracle" title="Oracle"><span class="oracle-logo"></span></a>
                &nbsp; &copy; 2019, Oracle Corporation and/or its affiliates
                <div class="footer-legal-links">
                    <a href="https://www.mysql.com/about/legal/">Legal Policies</a> |
                    <a href="http://www.oracle.com/us/legal/privacy/index.htm">Your Privacy Rights</a> |
                    <a href="http://www.oracle.com/us/legal/terms/index.html">Terms of Use</a> |
                    <a href="http://www.oracle.com/us/legal/third-party-trademarks/index.html">Trademark Policy</a> |
                    <a href="http://www.oracle.com/technetwork/community/oca-486395.html">Contributor Agreement</a> |
                    <div id="teconsent" style="display: inline-block"><script async="async" type="text/javascript" src="js/notice.js" crossorigin=""></script></div>
                </div>
            </div>

        </div>
    </footer>
</div>

        <script src="js/s_code_remote.js"></script>

        
    
</body>
</html>
